homepage Welcome to WebmasterWorld Guest from 54.161.197.188
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Pubcon Platinum Sponsor 2014
Home / Forums Index / Code, Content, and Presentation / Databases
Forum Library, Charter, Moderators: physics

Databases Forum

    
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.

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / Databases
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved