Zbigniew Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 29, 2014; 20:56
Zbigniew
Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
I'm going to establish a large database (ISAM) of simple structure, say the table with only 3 columns:
- VARCHAR(80) - VARCHAR(40) - DATE
The number of rows can be quite large, about hundred million or so. The first column, containing actual information, will contain unique values, unlike the two others - but the two others shall be used for data selection (and I'll index them).
Now to the point: considering, that the second column shall contain about 100-200 different "labels" - so in average many of such labels can be repeated one million times (or even more) - will it speed-up the selection done with something like "...WHERE label='xyz' AND date='2013-02-25' " (and maybe the insertion as well?), if instead of textual labels I'll use SMALLINT as simple integer "code" for each different "label" (and in my program a translation table)?
If so - will I have further performance gain, if instead of human-readable DATE for the third column I'll use "Unix time" put into INTEGER type column, not DATE-type?
And the final question: even, if so - is it worthy? I mean: will the supposed performance gain be significant (e.g. 2-3 times faster selection) - and not, say, just 5% faster (only possible to detect by using benchmarking tools)?
Thanks in advance for your opinions. -- Zbig
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
Oct 30
hsv Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 30, 2014; 19:37
hsv
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 30
Jan Steinman Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 30, 2014; 19:28
Jan Steinman
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 30
Jan Steinman Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Oct 30, 2014; 21:29
Jan Steinman
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 02
Zbigniew Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 02, 2014; 13:19
Zbigniew
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 02
Jan Steinman Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 02, 2014; 11:19
Jan Steinman
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 03
Hal?sz S?ndor Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 03, 2014; 09:58
Hal?sz S?ndor
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 04
Johan De Meersman Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 04, 2014; 13:22
Johan De Meersman
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 04
Jan Steinman Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 04, 2014; 11:04
Jan Steinman
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 06
Roberta Jask?lski Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 06, 2014; 15:49
Roberta Jask?lski
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 06
Zbigniew Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Nov 06, 2014; 22:40
Zbigniew
Re: Using INTEGER instead of VARCHAR/DATE - is this a way to faster access?
Search
Lasso Programming
This site manages and broadcasts several email lists pertaining to Lasso Programming and technologies related and used by Lasso developers. Sign up today!