homepage Welcome to WebmasterWorld Guest from
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, Moderator: open

Databases Forum

database performance

Msg#: 4353479 posted 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



Msg#: 4353479 posted 3:53 pm on Aug 19, 2011 (gmt 0)

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

brotherhood of LAN

WebmasterWorld Administrator brotherhood_of_lan us a WebmasterWorld Top Contributor of All Time 10+ Year Member Top Contributors Of The Month

Msg#: 4353479 posted 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