to pages?
Then just use the cursor-based api (I guess that's mysql_use_result) all the
time, and you won't have any memory problems at all. If you need to retrieve
pages (as in, the third block of 10 results, for instance) LIMIT is your
friend. Do read the documentation on limit, thoug
On 2012/02/09 01:40 PM, Johan De Meersman wrote:
- Original Message -
From: "Alex Schaft"
If I were to do a select count(*) from x where y prior to doing
select * from x where y to get a number of records, how would this impact
performance on the server itself? Would the first query be
- Original Message -
> From: "Alex Schaft"
>
> If I were to do a select count(*) from x where y prior to doing
> select * from x where y to get a number of records, how would this impact
> performance on the server itself? Would the first query be the one to
> do the most processing, with
Hi,
I'm currently using mysql_store_result to retrieve all records of a
query. This poses a problem however if say a couple of thousand records
get returned, and the user gets no feedback during the progress. I now
want to change this to mysql_use_result. The only catch is that you
I am not sure why they are doing it. You need to hack
the protocol to understand it.
Maybe some MySQL/network GURU will be able to help
yuo.
Regards,
Karam
--- Renald Buter <[EMAIL PROTECTED]> wrote:
> On 01:55 Tue 11 Jan , Karam Chand wrote:
> > Yup.
> >
> > This is a normal behaviour. mys
On 01:55 Tue 11 Jan , Karam Chand wrote:
> Yup.
>
> This is a normal behaviour. mysql_free_result() will
> result in bringing each unasked rows to the client and
> freeing it up row by row.
>
This sounds to me as a useless "feature". What could be the reason for
such wasting behaviour?
> BT
am having this issue with mysql_use_result: it
> seems it will iterate
> over all unused results if I call
> 'mysql_free_result'. The following
> code illustrates this:
>
> mysql_query(&mysql,"SELECT * FROM
> a_very_large_table");
> res = mysql_use_resul
Hello list,
I am having this issue with mysql_use_result: it seems it will iterate
over all unused results if I call 'mysql_free_result'. The following
code illustrates this:
mysql_query(&mysql,"SELECT * FROM a_very_large_table");
res = mysql_use_result(&
Hello list,
I am having this issue with mysql_use_result: it seems it will iterate
over all unused results if I call 'mysql_free_result'. The following
code illustrates this:
mysql_query(&mysql,"SELECT * FROM a_very_large_table");
res = mysql_use_result(&
Please reply to [EMAIL PROTECTED] (not to me personally),
so that others can follow this thread.
At 18:55 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> >Perhaps I misunderstood the doc but I thought by using _use_result
> >I was asking for the server not to send the next tuple until I as
At 18:09 -0700 10/6/03, Don Cohen wrote:
Paul DuBois writes:
> At 17:26 -0700 10/6/03, Don Cohen wrote:
> >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
> >says
> >
> > you must retrieve all the rows even if you determine in
> > mid-retrieval that you've found the
Paul DuBois writes:
> At 17:26 -0700 10/6/03, Don Cohen wrote:
> >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
> >says
> >
> > you must retrieve all the rows even if you determine in
> > mid-retrieval that you've found the information you were looking
> > for.
At 17:26 -0700 10/6/03, Don Cohen wrote:
http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html
says
you must retrieve all the rows even if you determine in
mid-retrieval that you've found the information you were looking
for.
My question is: why?
Because there is no provision
work very well. I type in
mysql_use_result() and get back messages that don't mention it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
- Original Message -
From: "Ritesh Nadhani" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, January 02, 2003 8:34 PM
Subject: mysql_use_result
> Greetin
Greetings...
When I am using mysql_use_result API to retrieve results, I am always
getting 0 value for the max_length member of MYSQL_FIELD structure which is
returned by mysql_fetch_fields.
But when I am using mysql_store_result, max_length has correct value.
Is this normal ? Is there any way
Hello
What do to if mysql_use_result return NULL ? I can't understand ?
I have only one query by connection, of course.
I talk about SELECT statement in my query (not INSERT or anything else)
Mysql run on linux.
>From time to time mysql_use_result() return NULL.
I throw and
Hi,
I had not answer at my first mail...
Sorry for posting it again but this is really important for us.
-Message d'origine-
De : Patrick FICHE [mailto:[EMAIL PROTECTED]]
Envoyé : lundi 12 février 2001 18:09
À : Mysql
Objet : Use of mysql_use_result in ODBC driver ?
Hi all,
I
Hi all,
I would like to change the do_query function in execute.c module in the ODBC
driver to use mysql_use_result function instead of mysql_store_result
function.
There is currently some comments with an eventual problem in case of
SQLRowCount function.
To my mind, the only thing would be
19 matches
Mail list logo
