Re: [GENERAL] query large amount of data in c++ using libpq

2007-08-19 Thread Henrik
19 aug 2007 kl. 06:34 skrev Felix Ji: Hi all, i am using PQexecParams() to "SELECT" about 3 million record in C+ +, and it takes several minutes to make it done with used memory dramatically incresed(about 200MB). it seems when i using PQexecParams(), i can't use the query result before al

[GENERAL] query large amount of data in c++ using libpq

2007-08-18 Thread Felix Ji
Hi all, i am using PQexecParams() to "SELECT" about 3 million record in C++, and it takes several minutes to make it done with used memory dramatically incresed(about 200MB). it seems when i using PQexecParams(), i can't use the query result before all the data is sent to client. is there somethin

[GENERAL] query large amount of data in c++ using libpq

2007-08-18 Thread Felix
Hi all, i am using PQexecParams() to "SELECT" about 3 million record in C++, and it takes several minutes to make it done with used memory dramatically incresed(about 200MB). it seems when i using PQexecParams(), i can't use the query result before all the data is sent to client. is there something