Hi!
Does anyone know any mysql options I can change in the my.ini file or mysql
variables to increase the speed of select statements?
About database:
-uses only select statements for queries
-no transactions
-if database becomes corrupt in anyway, not a big deal I can recreate it
-it is a small
: Derick Smith [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 19, 2003 9:08 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: suggestions - server options/mysql variables
Hi!
Does anyone know any mysql options I can change in the my.ini
file or mysql
variables to increase the speed
Eric
From: Mike Hillyer [EMAIL PROTECTED]
To: Derick Smith
[EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If you have queries that are only selects, in small tables, with few
rows, you should
: suggestions - server options/mysql variables
Date: Thu, 19 Jun 2003 09:13:33 -0600
If you have queries that are only selects, in small tables, with few
rows, you should have very fast performance as is. Are your queries
properly indexed? What hardware are you running on? What do these
queries look