Re: suggestions - server options/mysql variables

2003-06-19 Thread gerald_clark
ECTED]>, <[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 have very fast performance as is. Are you

RE: suggestions - server options/mysql variables

2003-06-19 Thread Derick Smith
ake a big difference. Thanks 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 y

RE: suggestions - server options/mysql variables

2003-06-19 Thread Mike Hillyer
; From: 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

suggestions - server options/mysql variables

2003-06-19 Thread Derick Smith
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 d