CE Phoenix Cart Forum

Hi,
Although the website customer load speed is till good, in admin because we have about 80,000 orders and 78,000 customer names, admin is now taking about 5 secs to load. Not a disaster but we're starting to notice more and more.. (Used to load in 1-3 secs)
Are there any tricks to speed up the database searches in admin? Any mysql indexing?
My VPS server is maxed out, LOADS of memory and as many cores active as we can buy.

Iain

Is it every page in admin, or just certain pages? Have you tried turning on page parse times? Have you tried turning on the slow query log in MySQL? Have you tried manually deleting old values from the session table? Some servers don't do that automatically. There's code floating around to do it by hook.

If the page parse time is low but the page speed is high, it may be something happening at the Apache (web server) level. For example, htpasswd strength too high: https://stackoverflow.com/a/64722818/6660678

For more help with that, post the algorithm from the admin/.htpasswd_phoenix file.

User1:$apr1$salt$passwordhash
User2:$2y$10$passwordhash

The algorithms are $apr1$ and $2y$10$ in those examples. Do not post the user names or password hashes in the forum. The salts would probably be all right but are not needed anyway. $2y$10$ to $2y$12$ should not be terribly slow on a maxed out VPS.

You'd probably have to be on 1.0.8.2 or newer to change the algorithm. But again, a maxed out VPS should not have trouble with apr1.

Large numbers of orders/customers should only impact pages that work with orders/customers. And even on those pages, I wouldn't expect a hundred thousand to significantly slow most queries. That's a big number for the kind of independent stores that run Phoenix. (Congratulations!) But it's not really a big number to a database.

If you can identify particular slow queries, we could likely provide more help with optimizing those.

Depending on your current version, you might find a newer version to be faster. For example, Burt observed a 20% speed improvement from 1.0.7.0 to 1.0.7.2 in catalog on one of his sites.

For speeding up a particular page, consider the following pieces of data:

1. Which page?
2. What action on the page? E.g. the default view, edit, preview, what?
3. The default version of that page action, or are you restricting by something? E.g. on the orders page, you might restrict the default list view by customer or order status.
4. Do you get a long list of results or just one or two?

Hi,
The only time I really notice any delay is when displaying a page of orders, ours is currently set to 25 orders per page.
For example, after pressing 'back' after looking at a single order, or pressing the 'orders' menu item.
Load times vary from 3-5 seconds.
Our admin htaccess is set at server level via Plesk rather than using the Phoenix htaccess settings so I have no idea on how many recursive decryptions are set.
Its an old version, version 1.0.5.0. I have added a couple of extra SQL queries to orders.php but these just parse the comments field of a single order for a particular phrase so shouldn't take long.
Sever logs show nothing unusual.
I am starting to think its more server based as the load times do vary somewhat.
I did used to use MYSQL workbench to directly connect to the MYSQL server, which provided lots of useful data, I might try that and see what it says.
Its not a big issue, part of me thinks maybe I'm imagining it so I need to get some stats somehow.
Thanks for your input.
Iain