Hi,

We're having some performances issues on our high traffic gallery. We get traffic spikes of 200+ concurrent users.

We're already on a 8 Core Powerful Standalone server but even with that 200+ concurrent users is grinding to a halt.

The server admins are saying the main cause is the select * from ZP_Images SQL which is taking time.

They suggested we might look into removing some of the table columns so.

So my question is, is it safe for me to remove any columns in the table that we don't use.

eg the Videoxxxxxx stuff?

See Screenshot
http://i.imgur.com/HQRMHi3.png

We don't have a any video etc. So those 15 Columns in the ZP_Images table are not required.

Many thanks in advance.

Technically that should work for all the metadata fields but note this has not been tried before. In any case be sure to disable the columns here before removing them:

• Options > Image > Metadata
• Options > Search > Search behaviour settings > Field list

Of course you will get the fields back on every update.

We will take a look if we can improve those parts for the next major version planned if it does not cause to many incompatibilies.

Thanks Acrylian, I'm going to take a backup just in case

I'll let you know how I get on.

Backup is always a good idea

Seems to have worked

Got it down from 120+ columns in that table down to 43.

Hopefully that will alleviate some performance issues

Great, hopefully it does work out for you.