Hello, I am running MySql on a Windows 2000 PIII-1Ghz PC with 256MB of RAM. I have three table that need to get updates when a new record gets created. I have minimized the number of indexes on the tables and the insert process goes like this: (All three tables have a primary key to prevent duplicates) Try Insert into table1… Except // Record already exists… End; Try Insert into table2… Except // Record already exists… End; Try Insert into table3… Except // Record already exists… End; Each table contains different data that is parsed from the data that is passed to the insert module. This module contains these three inserts. I am using CHAR fields rather than VARCHARS, because I read that MySQL handled these fields more efficiently (even though there is a cost in storage space). My question is: I am running the default NT version with the default settings, the table types are all MyISAM, however, I am only able to process approximately 7-10 transactions (into all three tables) per second. Is this a “reasonable” expectation of the performance I can expect? What server variables should I modify (if any) for better performance? Thanks for any advice, Dan Cumpian
--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
