• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

hardware requirements of database management system

jay75

Member
what are the special requirements of a database management system, in terms of hardware. there is an emphasis on great speed but each record will not be very large, say 100 bytes. throughput could vary drastically. for example which is more important fsb width or memory speed? raid would obviously definitely be needed.

thx, Jaysin.
 
It depends on the database, and what it is used for.

If it's the back end for small website, or small business general orders/works database, then it really doesn't matter. Careful database design, use of appropriate indexes, use of stored procedures wherever possible, use of denormalization where appropriate, careful writing of SQL queries (e.g. DISTINCT queries may be very slow, and use of subqueries may provide the same result more quickly), etc. can all boost database performance greatly.

Unless you are working with millions of rows, or thousands of database updates per minute, pretty much any decent PC with plenty of RAM will do the job perfectly adequately.

For very big, or very busy databases, the optimal hardware may need to be determined by performance profiling.
 
Back
Top