| From: | Ludek Finstrle <luf(at)pzkagis(dot)cz> |
|---|---|
| To: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
| Cc: | Antoine <melser(dot)anton(at)gmail(dot)com>, pgsql-odbc(at)postgresql(dot)org |
| Subject: | Re: faq? |
| Date: | 2006-01-27 22:43:36 |
| Message-ID: | 20060127224336.GB21342@soptik.pzkagis.cz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-odbc |
Fri, Jan 27, 2006 at 10:34:12PM +0000, Dave Page napsal(a):
> On 27/1/06 22:03, "Ludek Finstrle" <luf(at)pzkagis(dot)cz> wrote:
> >> inserts the way we do (ie, not via execute, but by opening a table and then
> >> doing AddNew) it might be something to look at... anyway, the boss told us
> >
> > Hey, does I miss something? There is no support for updateable cursors
> > in 08.01 psqlodbc driver. And it is marked as experimental feature in
> > 07.03 version.
>
> You don't need updateable cursors or declare/fetch to use AddNew in ADO/VB6.
Hmm. I don't know ADO/VB6->ODBC enough :-( I have to stop answer such
questions.
> much bigger data sets on large client/server databases. If all you are doing
> is adding new records, then you might even be able to add a 'WHERE 1=2'
It could be faster to use LIMIT on pgsql. But WHERE 1=2 is more
universal across different RDBMS.
Regards,
Luf
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ludek Finstrle | 2006-01-27 23:08:10 | psqlODBC 08.01.0108 Development snapshot |
| Previous Message | Ludek Finstrle | 2006-01-27 22:38:39 | Re: Disallow premature is broken |