Mario, Can you send a sample of the code that is causing this to happen? I have a couple ideas, but I would need to see the actual code to be sure.
You mention a "probable cause". Have you done anything to verify this (like get rid of the update and see what happens)? When you run the same query at the MySQL prompt, do you get the full result set you're looking for? Steve Meyers > -----Original Message----- > From: M. A. Alves [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, October 30, 2001 11:23 AM > To: [EMAIL PROTECTED] > Subject: 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 > > 20000 or 30000 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, Portugal mob 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 > > --------------------------------------------------------------------- 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
