SEO

#1 (**permalink**) 02-28-2008, 05:10 AM

Hi list,

I have a table with about 17 millons of records. This table
contain log of web for one month and I have an other table but with only
1 day of log.

If I do a select to get the log for this date 2006-01-01 :
Select * from mytable where mydate => '2006-01-01' and mydate <=
'2006-01-01'.

Do you think is more faster to do on table with have only one date or is
the same think if I do it on table whit all day ?

And last question, if I do a group by, I think the group by is
faster on column as type INT Vs Varchar ?

Ty for your reply

#2 (**permalink**) 02-28-2008, 05:12 AM

On Wed, 08 Nov 2006 15:38:27 -0500, Francis wrote:

> If I do a select to get the log for this date 2006-01-01 :
> Select * from mytable where mydate => '2006-01-01' and mydate <=
> '2006-01-01'.
>
> Do you think is more faster to do on table with have only one date or is
> the same think if I do it on table whit all day ?

That is what indexes are for.

> And last question, if I do a group by, I think the group by is
> faster on column as type INT Vs Varchar ?

Not necessarily so.

--
Leandro Guimarães Faria Corcete DUTRA +55 (11) 5685 2219
http://br.geocities.com./lgcdutra/ +55 (11) 9406 7191
mailto:leandro@dutra.fastmail.fm +55 (11) 2122 0302
xmpp:leandrod@jabber.org ymsgr:sendIM?lgcdutra BRASIL

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

Optimize question