On Wed, 21 Mar 2007, Elazar Leibovich wrote:
Date: Wed, 21 Mar 2007 16:02:22 +0200
From: Elazar Leibovich <[EMAIL PROTECTED]>
To: Jonathan Ben Avraham <[EMAIL PROTECTED]>
Cc: linux-il@linux.org.il
Subject: Re: [Job] MySQL consultation
The whole table. SELECT COUNT(*) FROM tbl WHERE id>1;
Thanks for the speedy reply.
Hi Elazar,
One to three minutes seems entirely reasonable to me, depending on
hardware.
You should probably be able to update a count of records accurately each
time you add to, or delete from, the table instead of using COUNT(*) to
re-count the *whole* table if you need to save time.
- yba
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: linux-il@linux.org.il
> 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 -
--
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]
