Author Topic: Database grows, gallery slows down.. what should I do?  (Read 3609 times)

0 Members and 1 Guest are viewing this topic.

Offline worldrailphoto

  • Pre-Newbie
  • Posts: 7
    • View Profile
Database grows, gallery slows down.. what should I do?
« on: October 30, 2006, 09:39:30 PM »
Hello  :)

I'm running a gallery on a low-specs server with no future of soon upgrades. At the very begginig it was running just fine, but after number of photos exceeded 5000 and database size 10MB the performance deteriorated to the inacceptable level.. especially when more than 10 users are browsing one need to wait for several minutes fot the main site to load. Looking at the database structure I found that
   
    4images_wordlist   22.132     MyISAM        1,1 MB
    4images_wordmatch       116.474     MyISAM        3,1 MB

comprise the majority of the database size.. Is this a source of my performance problems? Is there a chance to improve the performance of my 4img based gallery with some mods??
here's the url
http://stud.pam.szczecin.pl/~wizard

any help would be appreciated

best regards

PS I've skimmed the forum archive and did not find any solution

Artur

Offline Nicky

  • Administrator
  • 4images Guru
  • *****
  • Posts: 3.195
    • View Profile
Re: Database grows, gallery slows down.. what should I do?
« Reply #1 on: October 31, 2006, 06:52:26 PM »
change Webhoster ;)
cheers
Nicky
Your first three "must do" before you ask a question ! (© by V@no)
- please read the Forum Rules ...
- please study the FAQ ...
- please try to Search for your answer ...

nicky.net 4 4images
Signature stolen from mawenzi

Offline unite

  • Newbie
  • *
  • Posts: 48
    • View Profile
Re: Database grows, gallery slows down.. what should I do?
« Reply #2 on: November 03, 2006, 04:36:09 AM »
Yep get a new host.  :D

We can host your site... our servers are very fast. In fact we have over 6000+ images on one of our sites with no performance issues.

www.web-rocket.com