[ic] Admin Page Load Times Really Slow
Mike Heins
mike at perusion.com
Wed Mar 23 19:04:15 UTC 2011
Quoting IC (ic at tvcables.co.uk):
> Hi Folks,
>
> Our sql database has the last 123000 orders/customers in it, the admin page
> load times seem incredibly slow, 15 seconds from clicking the order tab to
> the page loading, editing an address takes the best part of a minute from
> hitting update to the page load.
>
> Are these times typical or is something wrong, its on a semi-dedicated VPS
> (6 accounts).
>
> The physical machine spec is Quad Core Intel Xeon 2.4GHz with 12GB ram,
> CentOS 5.0.
>
> The VPS has a guaranteed 2GB of RAM and 60GB disk space.
>
> Does it need a dedicated server?
We usually just set
Database transactions LARGE 1
in dbconf/mysql/transactions.mysql (or dbconf/pgsql/transactions.pgsql)
and skip the list display. I usually have a button I add where
you can list the last N orders.
--
Mike Heins
Perusion -- Expert Interchange Consulting http://www.perusion.com/
phone +1.765.328.4479 <mike at perusion.com>
The problem with Internet quotations is that many of them
are not genuine. -- Abraham Lincoln
More information about the interchange-users
mailing list