If you’re finding that your oscommerce based shop is extremely slow, try turning on the mysql cacheing to speed up regularly running queries.
You can also change the products table storage type to “innoDB” which can make a significant difference to the speed.
As always, please ensure that you make adequate backups of your data BEFORE applying any of the fixes mentioned above.
If you need any help with any of this just drop us a line and we’ll be glad to help.