Hello, Depending on what types of values are in your table, and the types of selects that you are going to perform, you will most likely notice a speed change if you were to INDEX some of your attributes...Just look up INDEX in the mysql manual...
I notice the largest improvement when I INDEX on an attribute that I am constantly using in a WHERE clause in my SELECT statement...It really helps MySQL when it goes to test the comparisons... Hope this helps... Chris -----Original Message----- From: Cael Mahold [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 09, 2001 4:20 PM To: [EMAIL PROTECTED] Subject: speed up MySQL Selections Hello, i have a question. I will have to set up a MySQL Database which will have a hughe amount of entries in a table. I did some tests and my select statements would need lot of time. I just wanna ask if there are some generally ways to speed up performance of mysql statements? thanx in advance bye Rüdi --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
