Actually, that seems to be a rather small database. I work with MySQL at work, and our tables reach into the millions of records before we start seeing any noticeable problems. However, I would read this: http://www.phpcomplete.com/tutorials.php?id=61&sec=readTutorial And this: http://www.phpcomplete.com/tutorials.php?id=59&sec=readTutorial You might want to also ensure that you have normalized your database where needed, and also denormalized for performance. Jason On Sunday 15 December 2002 23:14, Thomas Jones wrote:
-----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=i ndex
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-----
-- Jason Lotito - www.phpcomplete.com