[]scroungr said: using only version 3.23 of Mysql? Consider upgrading that to MySQL 4.1.11 [/] Hello I have a small machine (PII 400, 96MB) (fedora core 1) on my room for experimenting things. I loaded 350MB (450K rows of data in w3t_Posts) of data to mysql 3.23. Using Ubbthreads 6.4.2, I tried to search the word 'Nokia' with the option '5 years'. The average was 430 seconds when I tried to search on the same keyword. Then I downloaded mysql-4.0.24 rpm package and did an upgrade. After it was done I tried to search the same keyword 'nokia' with the same amount of data. The result was 545 seconds in average (never reached below 500 seconds). I don't know what's going on here.
...... x ...... Using UBBt 6.4.2 + Digg Ajax Mod, Trust Ajax Mod, Captcha Regristation & Login mod, Checkusername Ajax mode.
|