RE: What are MYSQL_RES limits ? -- update

2001-10-31 Thread M. A. Alves

Some other useful information on this problem:

I have tried the operation in two other ways, both based on a version of
the program with only one connection using the API and emiting the UPDATE
statments on standard output:

  1. output piped onto mysql -- failure :-(

  2. output saved on a file, then input to mysql -- success :-)

This fits my diagnosis that it has to do with concurrent access to the
same table.

Thanks,

-- 
   ,
 M A R I O   data miner, LIACC, room 221   tel 351+226078830, ext 121
 A M A D O   Rua Campo Alegre, 823 fax 351+226003654
 A L V E S   P-4150 PORTO, Portugalmob 351+939354002




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




What are MYSQL_RES limits ? -- update

2001-10-30 Thread M. A. Alves

On Tue, 30 Oct 2001, M. A. Alves wrote:
 I seem to be hitting a ceiling in MYSQL_RES (mysql_use_result).  I select
 2 or 3 items but only 2295 are returned.  What might be the cause
 of this?

The probable cause is I was accessing the same table at the same time (but
thru different connections).  However I am surprise MySQL cannot cope with
this kind of concurrent access.  Or can it?  One access was selection and
the other was updating.

Thanks a lot,

-- 
   ,
 M A R I O   data miner, LIACC, room 221   tel 351+226078830, ext 121
 A M A D O   Rua Campo Alegre, 823 fax 351+226003654
 A L V E S   P-4150 PORTO, Portugalmob 351+939354002



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php