Hi!
> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
Emmanuel> Hello Monty,
Emmanuel> With your help I'm getting the understanding I was looking for, thank you.
>> Note however that if there would have been less matching rows (for
>> example 60), the SQL_CALC_FOUND_ROW
Hello Monty,
With your help I'm getting the understanding I was looking for, thank you.
On 27 January 2002 23:23, Michael Widenius wrote;
> Hi!
>
> > "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
>
>
>
> >> This will of course slow down any query significantly, if the
Hi!
> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
>> This will of course slow down any query significantly, if the WHERE
>> clause matches a lot of rows, but should still be faster than:
>>
>> - retrieving all rows to get a count.
>> or
>> - Do two queries:
>> SELEC
Emmanuel van der Meulen writes:
> Hello Monty,
>
> I downloaded and installed 4.0.1 for the SQL_CALC_FOUND_ROW option.
> However, the query runs 600% longer, so the saving I get with FOUND_ROWS()
> running in 0.0 secs does not serve me. Am I maybe doing something wrong?
>
> Here is what I did;
rds
Emmanuel
> -Original Message-
> From: Michael Widenius [mailto:[EMAIL PROTECTED]]
> Sent: 21 January 2002 00:44
> To: Emmanuel van der Meulen
> Cc: MySQL General List; MySQL Java List
> Subject: RE: Understanding throughput with JDBC
>
>
>
> Hi!
>
ROTECTED]]
> Sent: 21 January 2002 00:44
> To: Emmanuel van der Meulen
> Cc: MySQL General List; MySQL Java List
> Subject: RE: Understanding throughput with JDBC
>
>
>
> Hi!
>
> >>>>> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]>
Hi!
> "Emmanuel" == Emmanuel van der Meulen <[EMAIL PROTECTED]> writes:
Emmanuel> Hello Mark,
Emmanuel> Thank you for the note and feedback. BTW, it was not over a network. Both
Emmanuel> on local PC. So all the time went into building the resultset in memory.
Emmanuel> I'm surprised at
ED]>; "Nick" <[EMAIL PROTECTED]>
Sent: Sunday, January 20, 2002 12:46 PM
Subject: RE: [OT] Re: Understanding throughput with JDBC
> Hello Nick,
>
> Does ROWNUM exist in MySQL?
>
> Kind reagrds
> Emmanuel
>
> > -Original Message-
> > From: Ni
Hello Dave,
Thank you. This works.
Kind regards
Emmanuel
> -Original Message-
> From: Adrian Monea [mailto:[EMAIL PROTECTED]]
> Sent: 20 January 2002 15:08
> To: 'Emmanuel van der Meulen'
> Cc: [EMAIL PROTECTED]
> Subject: RE: Understanding throughput with
Hello Nick,
Does ROWNUM exist in MySQL?
Kind reagrds
Emmanuel
> -Original Message-
> From: Nick [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 20:41
> To: Shankar Unni
> Cc: [EMAIL PROTECTED]
> Subject: [OT] Re: Understanding throughput with JDBC
>
>
>
Mark Robson [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 16:49
> To: MySQL Java List
> Subject: Re: Understanding throughput with JDBC
>
>
> > B. When running the exact same select as stated above in a java program
> > using JDBC, from when issuing, ResultSet rs
rom: Mark Matthews [mailto:[EMAIL PROTECTED]]
> Sent: 19 January 2002 16:25
> To: Emmanuel van der Meulen
> Cc: [EMAIL PROTECTED]
> Subject: Re: Understanding throughput with JDBC
>
>
>
> - Original Message -
> From: "Emmanuel van der Meulen" <[EMAIL PROTE
Hello all,
Could anyone please assist me to understand this. I want to understand
where the time is going to and whether there is something I can do about it,
with the following query when using JDBC;
Here is the table declaration;
CREATE TABLE Memberships ("EMAIL CHAR(60) NOT NULL,
13 matches
Mail list logo
