-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, Has anyone here ever tred the waters of database optimization? More precisely a mysql database. I have constructed a database of "Linux" links for my website and have compiled a comprehensive database. So much that the mysqld daemon seems to be a bit slow upon processing the indices. Here are my specs: Data 2,636 KB Index 106,496 Bytes Total 2,740 KB <-----------Database Size Format dynamic Rows 12,636 <-------Database Entries Row length ø 213 Row size ø 222 Bytes Next Autoindex 12,643 I am currently running a 400mhz, 128MB RAM, SuSE 8.1 system.....using mysql version 3.23.52.....on a cable trunk. You may test/see the speed of my test database at the following url: http://12.222.161.151/postnuke/modules.php?op=modload&name=Web_Links&file=index Thanks! - -- Thomas Jones i-Null.com Network Administrator -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.7 (GNU/Linux) iD8DBQE9/VMp9w7alPkpvvsRApcFAKDFPdOiN+m535ybLBo2VFtrAJtD/wCcCG4V ed1o+xgl6XvcT2eru4SFgCg= =HEKO -----END PGP SIGNATURE-----