The whole table. SELECT COUNT(*) FROM tbl WHERE id>1; Thanks for the speedy reply.
On 3/21/07, Jonathan Ben Avraham <[EMAIL PROTECTED]> wrote:
Hi Elazar, What is it exactly that you are counting? - yba On Wed, 21 Mar 2007, Elazar Leibovich wrote: > Date: Wed, 21 Mar 2007 15:42:21 +0200 > From: Elazar Leibovich <[EMAIL PROTECTED]> > To: [email protected] > Subject: Re: [Job] MySQL consultation > > It seems that my question boils down to this: > I'm having a 3Gb table with three TEXT columns and an ID. > Counting it takes between 1 to 2 minutes, is it normal for such a size > of a table? > > On 3/21/07, Elazar Leibovich <[EMAIL PROTECTED]> wrote: >> I need a MySQL consultant for a small consultation (20 min.) to help >> me designing a DB for ~30mil rows, whose size is about 10Gb. The >> consultant must have proven experience with building using and >> optimizing DBs of this scale. I only need to consult him by phone for >> 10-20 minutes, consultation by email is also possible. I need it >> pretty soon. >> >> Regards >> Elazar Leibovich >> 054.4 9 6 7 7.8.4 >> > > ================================================================= > To unsubscribe, send mail to [EMAIL PROTECTED] with > the word "unsubscribe" in the message body, e.g., run the command > echo unsubscribe | mail [EMAIL PROTECTED] > > -- EE 77 7F 30 4A 64 2E C5 83 5F E7 49 A6 82 29 BA ~. .~ Tk Open Systems =}------------------------------------------------ooO--U--Ooo------------{= - [EMAIL PROTECTED] - tel: +972.2.679.5364, http://www.tkos.co.il -
================================================================= To unsubscribe, send mail to [EMAIL PROTECTED] with the word "unsubscribe" in the message body, e.g., run the command echo unsubscribe | mail [EMAIL PROTECTED]
