help with drain on server

[Kim]

... that doesn't appear to be a Zen Cart shop

[widget40]

sorry the full url to the store is www.djb.co.nz/store

[widget40]

These are my server settings. Maybe it may shed some light.

Settings from your VPS:

PHP 5.2.9 (cli) (built: Nov 25 2009 19:37:52)

Server version: Apache/2.2.14 (Unix)

mysql Ver 14.12 Distrib 5.0.89,

register_globals = Off
safe_mode = Off

PHP modules: (curl / ssl compiled in)

[PHP Modules]
bcmath
calendar
ctype
curl
date
dom
exif
filter
ftp
gd
gettext
hash
iconv
imap
ionCube Loader
json
libxml
mbstring
mcrypt
mhash
mime_magic
mysql
mysqli
openssl
pcre
PDO
pdo_mysql
pdo_sqlite
posix
pspell
Reflection
session
SimpleXML
soap
sockets
SourceGuardian
SPL
SQLite
standard
tidy
tokenizer
wddx
xml
xmlreader
xmlrpc
xmlwriter
xsl
Zend Optimizer
zip
zlib

[kobra]

These are my server settings. Maybe it may shed some light.

As a VPS - this is most likely a default LAMP configuration
I also suppose that you have root access
There are many .cnf files that one can "TUNE" to optimize for database intensive operations
This forum is not the venue for server setup/tweaking but there are many out there

[widget40]

Thanks for your reply. I was just trying to find out whether it is a server issue or a zencart issue. I will go back to the server and discuss this more with them.

If anyone else has anymore suggestions i am still open to them. thanks.

[kobra]

Thanks for your reply. I was just trying to find out whether it is a server issue or a zencart issue. I will go back to the server and discuss this more with them.

If they are not familiar with ZenCart they will probably "freak" at the number of querries - -
They need to know that these are well indexed tables - as much as can be and that there are servers that can run ZenCart very quickly
On a VPS they will likely try to up sell you to additional resources

[widget40]

You are probably right. They did ask me if i wanted a dedicated server. I have only 80 small sites and only fill the server by a third. financially it is not viable to upgrade to dedicated. I have found that moving from shared to vps a little better in the sense of control etc. speed a bit better.