Re: Large selects - Mailing list pgsql-jdbc

From Koth, Christian (DWBI)
Subject Re: Large selects
Date
Msg-id F5F602C218633C419C7BCA6CDDC6E90A02599086@COSSMGMBX04.EMAIL.CORP.TLD
Whole thread Raw
In response to Large selects  (Bendik Rognlien Johansen <bensmailinglists@gmail.com>)
List pgsql-jdbc
Bendik,

- Loop through the results, building a Lucene index.

I guess you are trying to search within the contact data and therefore using lucene? Why not using the database build
inpossibilities for searching using SQL? 


- Does anyone have any suggestions on how to deal with this, other that throwing more hardware at the problem? Cursors?

We are using cursors to access large result sets which works quite well. Also with postgres JDBC you can use scrollable
resultsets (only forward scrolling) and a limited fetch size. 

Christian


******************************************
The information contained in, or attached to, this e-mail, may contain confidential information and is intended solely
forthe use of the individual or entity to whom they are addressed and may be subject to legal privilege.  If you have
receivedthis e-mail in error you should notify the sender immediately by reply e-mail, delete the message from your
systemand notify your system manager.  Please do not copy it for any purpose, or disclose its contents to any other
person. The views or opinions presented in this e-mail are solely those of the author and do not necessarily represent
thoseof the company.  The recipient should check this e-mail and any attachments for the presence of viruses.  The
companyaccepts no liability for any damage caused, directly or indirectly, by any virus transmitted in this email. 
******************************************

pgsql-jdbc by date:

Previous
From: Roland Walter
Date:
Subject: Re: Large selects
Next
From: "Peter Neu"
Date:
Subject: WG: HowTo: Scheduled User Management?