Home› General support

zp_images table - Safe to remove unused columns?

darkufo Member
in General support
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.

Comments

  • acrylian Administrator, Developer
    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.
  • darkufo Member
    Thanks Acrylian, I'm going to take a backup just in case :)

    I'll let you know how I get on.
  • acrylian Administrator, Developer
    Backup is always a good idea ;)
  • darkufo Member
    Seems to have worked :)

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

    Hopefully that will alleviate some performance issues ;)
  • acrylian Administrator, Developer
    Great, hopefully it does work out for you.
Sign In or Register to comment.