| From: | "Vikram Sulakhe" <sulak001(at)bama(dot)ua(dot)edu> |
|---|---|
| To: | <pgsql-odbc(at)postgresql(dot)org> |
| Subject: | Accessing PGSQL |
| Date: | 2002-09-10 04:55:19 |
| Message-ID: | 003b01c25886$43218f50$8ea1a082@redstorm |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Hi!
Is there a way to execute a SQL query directly from a Win NT machine, on a
pgSQL database that is remotely installed?
I tried using CRecordset Object to connect to this remote pgSQL database.
But if I have a very large database (say 10,000 records), then searching for
a particular record takes lot of time as we need to traverse through all the
records in CRecordset.
I can use m_strFilter property of CRecordset, but then I have to open the
database again and this is also very time consuming process.
So I am looking for a quick way to locate a particular record in a
collection of say 10,000 records.
Is there a work-around for this?
Regards,
Vikram
| From | Date | Subject | |
|---|---|---|---|
| Next Message | mlw | 2002-09-10 13:29:58 | Re: Accessing PGSQL |
| Previous Message | Willy HOUBEN | 2002-09-09 16:57:13 | base de donnée à réaliser en urgence |