RE: logging_event_property column sizes

2004-06-20 Thread Simon Dorrat
TECTED] > Sent: Saturday, 15 May 2004 10:38 AM > To: 'James Stauffer '; ''[EMAIL PROTECTED]' ' > Subject: RE: logging_event_property column sizes > > Actually, if the coumn is a varchar one, then no space is wasted from what > I > remember. Onl

Re: logging_event_property column sizes

2004-05-15 Thread Ceki Gülcü
At 03:31 PM 5/14/2004, James Stauffer wrote: In logging_event_property both mapped_key and mapped_value are 254 characters. I don't think I have any keys longer than about 10 characters but I do have values more than 254 characters. What would you think of decreasing mapped_key to something like

RE: logging_event_property column sizes

2004-05-14 Thread Paul Smith
Actually, if the coumn is a varchar one, then no space is wasted from what I remember. Only the exact # chars for the row is allocated. Having said that, I can speak from my own personal experience with some DB's when I recommend an actual fixed size column (char). If you can get a table's row si