Re: [DB] queries on large tables crashes on Windows

Hi, Are you sure that the fault is within DB? Did you try to use another method, like MDB or mysql_* functions built in to PHP? Or, if that fails, try Java or Perl connectivity. Did you check the MySQL query in the command-line tool? Robert On Fri, 2003-09-12 at 04:27, Voyteck wrote: > Hello, > > I came to very strange problem, which I cannot find the source of for > quite a long time. > I use PEAR::DB (newest) to connect and perform operations on pgsql > database. Everything works fine until I try to query (using query() or > getOne() method) large table (about 8000 records). Then PHP (v 433) on > Windows crashes (Apache webserver). > Quite interesting is that I do not want to fetch any large data - the > query I perform is "select count(*) from table" - so it replies in fact > with only one row. When the table is almost empty (contains less > records) - the query works without problems. > I tries to run the same query using PHP built-in functions (pg_query()) > - and it runned without problems. > > Can anybody help me or maybe this is some kind of bug ? > I can provide full info about this situation. > > Thanks in advance for any help. becouse this case is very important for > me - I would be very gratefull for sending the replies CC to my private > email - voyteck@caffe.com.pl. I really count on you people :) > > Best regards > > Wojciech Zielinski -- Robert Munteanu <rombertworf@xnet.ro> ------------------------------------------------------- Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV AntiVirus. Xnet automatically scans all messages for viruses using RAV AntiVirus. Nota: RAV AntiVirus poate sa nu detecteze toti virusii noi sau toate variantele lor. Va rugam sa luati in considerare ca exista un risc de fiecare data cand deschideti fisiere atasate si ca MobiFon nu este responsabila pentru nici un prejudiciu cauzat de virusi. Disclaimer: RAV AntiVirus may not be able to detect all new viruses and variants. Please be aware that there is a risk involved whenever opening e-mail attachments to your computer and that MobiFon is not responsible for any damages caused by viruses.