I have a problem with a database, it take more than 30s to load a page,
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