Site crash very often

Hello Asep,

Can you describe what sort of crash you are seeing...for example:

Is your website going unavailable, and then later it works?

Or is just nothing being displayed, which means the database has crashed? If so, what are you then doing to fix it?

Assuming that when your site is working that everything is fine (and fast pages), then both of the above conditions would indicate a problem at your host rather than with your particular site; so it might be worth asking them if they are aware of any problems on the server that your site is on...

Cheers,
David.

Hello,

Yes sometimes it's become unavailable and sometimes mysql erorrs (cannot connect to database)

When i contacted hosting technician regarding this issue, he said:

{email content saved}

Cheers,

Asep

Hello Asep,

Thanks - whilst the script is not limited in any way; ultimately of course there are going to be physical limitations - if you have hundreds of thousands of products then MySQL has to be able to create a temporary table in order to order those records by price, relevance etc.

I appreciate that this may be a lot of work; however what I normally recommend for customers wishing to publish hundreds of merchants is actually to create multiple installation of Price Tapestry in sub-directories; and effectively create a category hierarchy by doing this. For example, an installation in:

http://www.yoursite.com/electronics/

...would contain all your electronics merchants, and

http://www.yoursite.com/fasion/

...would contain all your fasion merchants etc.

There is lots of information about this, and putting a search box for all categories at the top level of your site on this page:

http://www.pricetapestry.com/node/205

In the mean time; it is possible that automated (i.e. search engine spider) requests are generating unnecessary requests to search.php and in particular the sort by links, so it might be worth putting a robots.txt exclusion for these pages if you do not already have one.

Have a look at the robots.txt that I use on the demo site here- I think this will help quite a lot if you are not already using one...

Cheers,
David.

Ok David i would try it out. Thanks.