[DB] queries on large tables crashes on Windows

From: Date: Fri, 12 Sep 2003 01:27:57 +0000
Subject: [DB] queries on large tables crashes on Windows
Groups: php.pear.general 
Request: Send a blank email to pear-general+get-7757@lists.php.net to get a copy of this message
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

« previous php.pear.general (#7757) next »