Welcome to WebmasterWorld Guest from 184.108.40.206 , register , free tools , login , search , pro membership , help , library , announcements , recent posts , open posts Become a Pro Member
database performance farhaty msg:4353481 3:21 pm on Aug 19, 2011 (gmt 0) 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 msg:4353488 3:53 pm on Aug 19, 2011 (gmt 0)
any help yet... hmmm ... where are these webmasters?!
brotherhood of LAN msg:4353490 4:02 pm on Aug 19, 2011 (gmt 0)
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.