On Thu, Nov 06, 2003 at 10:44:04AM -0600, Paul Fine wrote: > Greetings. > > Does anyone have any suggestions besides trial and error for determining how > resource intensive my database is going to be? > > Is this just something the a developer just gets a feel for after developing > a number of databases or are there some guidelines I can use?
The best solution I've found, aside from intimate knowledge of the application and db server software, is testing. Do some stress testing on whatever hardware you can get your hands on. That'll often provide some good idea about whether it's going to be a CPU, RAM, or I/O hog. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 53 days, processed 2,004,069,950 queries (431/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
