> Hello, > > i have a question. Don't we all :-) > 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?
Indexing, indexing, indexing. It can't be said too many times. Learn to use EXPLAIN SELECT ... to see how MySQL makes use of the indexes you define. Then learn to use SHOW STATUS and understand what it tells you. The manual is quite thorough in explaining what each line means. This is an excellent tool to track down problematic queries. - Lastly, set key_buffer in my.cnf as high as you can without stealing too many resources from other processes. This is the last step, though. No amount of RAM or other hardware will help you, unless you take a good look at the other issues above. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq --------------------------------------------------------------------- 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
