Hi,

Hope someone can help or explain about my problem.

I just installed 1 new website with files and database (separated not using together) from my current website.
Both of them (2 websites) totally same except the new one has new blank database for customers (I delete it from PhpMyAdmin).

The problem is when trying to update product catalog, the old website is very slow but the new one is so fast.

My questions, is it related with the customer database I deleted in new website?
So the new one without customer database run faster than old website (current has around 5.000).

I also wonder if the problem might be in /tmp folder?
Is it safe to delete? I am planning to rename the folder name and make a new /tmp folder with empty files inside.

Thanks in advance for the help.



Regards,



Suryanto

So 2 websites using the same database but you emptied the customer table ?
Slow when both sites are running at the same time? Faster when only one is being accessed?
You on a cheap shared hosting plan with limited resource (eg 64MB ram) ?

Many possible issues.
Simon

@soundsgood
Thanks for the reply.

Sorry for my unclear explanation.
Actually all (files and database) are totally separated so between 2 website has not connected at all.
I just copied everything from my previous website and make a new one.
But I deleted the customer database in new website.

The previous website is slow when try to update products (eg. add new product).
But with the new website is much faster.
Maybe it takes 1-2 minutes after clicking "insert" but new website only takes around 5 seconds.

Thanks again!

You could truncate (empty) the customer table but I doubt it'd work at all if you dropped (removed) the customer table.

Ok so you're running 2 websites on one server - so I'd look for other differences between the 2 carts.
Does the slow one have more categories / products and more images than the fast one?
Preloading product images in the admin and having many categories subcategories will make it much slower.

If you have a 6.4.2 or 6.5 cart you can switch off preloading images under Admin >> Configuration >> Images.
Does the server use any compression or expiry headers?

Can't really help much - not enough info.

Simon

Again, thanks for the help.

Yes, 2 website running on same server but Each website run in different database.
Everything is same, but I deleted the customer database in new website since it consider as a new website.

Unfortunately I am still using 6.2.

So far, I suspicious 1 thing which is file in /tmp folder.
It is slow when open /tmp folder in my old website (which running around 5 years) using FTP.
But has no problem when open /tmp folder in new website.

Is it okay to delete the folder?
Not delete but I will rename the /tmp folder with other name and make a new /tmp folder instead with empty files inside.

Thanks!

Not heard of a /tmp folder slowing down a website unless it's being used for caching eg sessions in which case you really need to upgrade, caching sessions in the filesystem is not a good idea. Or it could be caching category info. Check Admin >> Configuration >> Sessions (only prevent spider should be true) and also Admin >> Configuration >> Cache (I'd switch it off)

Can't see any issue deleting it, its a (temp)orary folder after all. Just make a new one after it.

Simon

I'm not sure I see anything in this thread to really confirm that these sites are running on the same server. If the FTP access keys are different for each one, I'd presume server differences until proven otherwise.

In that case, the differences could be explained by a "closer" data center, faster cpu and/or server components and a database which was more effectively optimized than the original during the copying process.

Are the PHP versions the same? Are the components older or newer than the original site?

Are both sites using open basedir and have the configuration table elements pointing to directories been properly updated to point within that base directory restriction set on the new site? (an open basedir violation may cause some odd effects, including 'short circuiting' the running of some code in certain circumstances, thus reducing the amount of code executed and 'improving' speed, though it more often slows site execution...)

Anyway, interesting problem...

David

@Simon & David

Thanks for the reply.

The problem is solved by replacing /tmp folder with new one.
Now everything is faster, especially when try to add new product.

Thanks for everything, especially to make sure changing /tmp folder is okay.


Regards,



Suryanto

If that is the only change then I doubt it's the long term solution, esp if it's being used as a cache.
You'll probably end up with the site slowing down again as the cache fills. Wouldn't recommend using page caching in the filesystem (which sounds like it's what its doing.)

Simon

Sorry forgot to mentioned that I also follow your instruction.
The configuration was set like you said so I turned it off too.

Once again, thanks for the advise!

Looking back at this, I can see I missed the /tmp/ folder information mentioned previously.

Yes, this could explain some slowness in earlier versions of the cart, though logically as 6.3+ carts don't store sessions in the file system at all you would not expect that in newer carts.

So, I'm presuming this is an older cart, which was being slowed down by an excessive number of session files stored in the tmp folder. One good reason to upgrade...

David