p51b.mustang wrote:

> Looking at the tables I think your right on the varbinary 8& 16. Are you making the TEXT fields varchar(8000)? or optimizing.
> I've installed piwik to understand where you are coming from, but I need to tidy it up as I'm getting jquery error (as usual, no big deal) and my zend library is located under the php directory.
> But, at least I can understand the MySQL table structure.

Glad you can ;)
Seriously, I've used BLOBs in some places, and I'm having a problem with hitting
limit's I think because of running everything UNICODE, so the sum of all the
fields is just too much. The 'custom variables' are giving me a bit of trouble,
but personally I would have implemented them as a separate table so one does not
have a fixed limit. Next step though is to replace the rest of the
varchar(4/8000) with blob's you can't get three unicode varchar(8000) in the one
table ... but this is mainly in the logger which I'm not actually using at the
moment.

I've cloned a copy of the SVN, which I'll convert to Hg and then run BC to merge
changes back into the base code. At which point I'll have a clean working copy.
Yes I know I should have been tracking things with the DVCS as I went along, but
it's easier just to get things working, THEN work back through the changes and
tidy them up. I often find a few mistakes or areas where an alternative would
work better. And no one sees the sillies ;)

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php