[PERFORM] What is the fastest way to get a resultset

I'm very new to Postgresql, so don't beat me up to bad if you see a problem, just inform me what I've done wrong. I'm use Postgresql 7.2 (PeerDirect's Windows port) on Win2000 384MB RAM 10GB of Free space 800 Mhz, using the ODBC driver 7.03.01.00. I have a table that has 103,000 records in it

Re: [PERFORM] What is the fastest way to get a resultset

or is this a limitation that it has? Thanks Jeff [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Mon, 25 Aug 2003, Bupp Phillips wrote: I have a table that has 103,000 records in it (record size is about 953 bytes) and when I do a select all (select * from table) it takes

Re: [PERFORM] What is the fastest way to get a resultset

not be supported on another database. Neil Conway [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] On Tue, Aug 26, 2003 at 02:18:23AM -0700, Bupp Phillips wrote: It there a way to get server side cursors with Postgresql like SQLServer has or is this a limitation that it has? http