database performance

[farhaty]

Hi Webmasters,

I have a problem with a database, it take more than 30s to load a page,

database descriptions:

engine: MyISM
size: 1.26GB
tables: 2 tables
1st table: 42 fields
2nd table: 3 fields

rows: 226.521 rows

My VPS :

4096 MB RAM
2 CPU (4GHz)


the page was loading normal when the database has < 150000 rows.

it is better to create multiple tables or just one table for a huge database?


Please help me to perform this database, and give me advices how to perform huge database

Thank you

[farhaty]

any help yet... hmmm ... where are these webmasters?!

[brotherhood of LAN]

farhaty, welcome

Have patience. Free help is worth the wait surely!

You should find out which queries are causing your pages to load slowly. Try using the EXPLAIN [dev.mysql.com] syntax to evaluate how MySQL is parsing your query and if it is using indexes where it should be.

There are a number of optimizations you can use to tune the database server, but most importantly, make sure your queries are tip-top first.