suitable database

[shukla]

Hello!!
I am developing ERP type software in vb.
Currently i am using access as database
so please can u suggest me any suitable database for the same.
Right now i have 250 tables in my database.
Thanks.

[GaryMazzone]

My choice would be SQL Server or Oracle. MySQL would work also

[shukla]

but can it be fast enough ?
as i have worked only with access database, its very slow if no. of records increased so i dont have any idea about other database .

[FunkyDexter]

Oracle or SQL Server would definitely be fast enough. They're both used by major companies for Enterprise level systems. I don't know enough about MySQL to comment but from what I gather it should also be just fine.

You do know how to make a database perform though. You need to know about tuning, indexes, when to denormalise, maintenance, hardward requirements etc. There're loads of ways of speeding up a database if you know what you're doing (and loads of ways of slowing it down if you don't).

[shukla]

Thanks GaryMazzone & FunkyDexter .
So finally i will use sql server database.
But i must learn all methods to speed up the database.
I m searching on net for the same.
But can u tell me any website for getting knowledge for this.
Thank u once again.

[FunkyDexter]

To be honest, there isn't a single source you can go to. It's such a huge subject that it's really only something you can pick up with experience.

If you start by making sure your database follows third normal form (just google 'third normal form' if you want an explanation of that) and how and when to set up indexes on commonly queried fields (again, google will give you more answers quicker than we could hope to here) then you won't be going too far wrong. You should also look up how to set up a routine overnight job to maintain your indexes as they do degrade over time. If you've got those basics right then, if you get slow perfomance in a specific area you can investigate and resolve it.

For hardware you should ideally look up the Microsoft recommended configurations but that's usually the responsibility of your customers IT department rather than yours as a software vendor.