RE: What are MYSQL_RES limits ? -- update
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
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