Quote Originally Posted by SpaceMonkey View Post
Hi all,

Has anyone noticed the size of their database whilst running this module?

I notice that it stores all transactions as blob data which have now mounted to quite a size..... +200mb. Even my email achieve isn't that big...….

Due to the size of the worldpay table I have been unable to restore the database successfully, I have manually restored each table (except worldpay) and can use my store still but things must be missing! Does anyone know how to calm this module down a little???? Is there a better way of storing the data for this module?

Any input greatfully received.
Hi SpaceMonkey,

it is something I've noticed before, but not to your extremes.

How many records do you have? I've over 2500 with a table size of approx. 20Mb. An average blob in my db is only 2-3kb.
Each blob saves anywhere upto 6,000 characters. Is there a more space efficient data type within mysql to store that number of characters?
TBH I'm not sure if it is essential to record all of the various blobs, i.e. could we drop the 'session blob'. Is it ever used by anyone and for what purpose?

I've been tweaking a version of the module to try and incorporate a few improvements, but dealing with the support agents at Worldpay to ensure we're utilising the best options is not only time consuming, but confusing too (I don't think half their tech support team know how to communicate with their gateway).

If there's no reason to keep all the blob info, we could look to ditch some of it in a newer module.


Rich