Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-11-06 Thread Zbigniew
2014-11-06 21:49 GMT+01:00, Roberta Jaskólski : > Ugh--I missed the discussion shift from the DATEs to the VARCHAR labels ... > and now I wholeheartedly agree with you. > > As for the DATEs, I yet suspect that for performance maybe TIMESTAMP is > slightly better than DATE. Well what I'm interest

Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?

2014-11-06 Thread Roberta Jask�lski
2014/11/04 11:04 -0800, Jan Steinman I was not suggesting it for dates. The OP appeared to have a well-defined set of strings in a VARCHAR field — THAT is what I suggested ENUMs for! What is the update frequency of those VARCHARs? If you're adding them often — or if you need to