X-Original-To: pgsql-performance@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id CA6FE475CBC for ; Tue, 29 Apr 2003 11:44:02 -0400 (EDT) Received: from mail.reviewer.co.uk (frodo.reviewer.co.uk [213.232.121.13]) by postgresql.org (Postfix) with SMTP id AFAB247633C for ; Tue, 29 Apr 2003 11:43:22 -0400 (EDT) Received: (qmail 27486 invoked from network); 29 Apr 2003 15:43:27 -0000 Received: from unknown (HELO LAIKA) (62.49.176.243) by mail.reviewer.co.uk with SMTP; 29 Apr 2003 15:43:27 -0000 From: "Robert John Shepherd" To: Subject: Re: Best ODBC cursor and lock types for fastest reading? Date: Tue, 29 Apr 2003 16:43:26 +0100 Message-ID: <001a01c30e66$138f0920$f3b0313e@LAIKA> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook, Build 10.0.2627 In-Reply-To: <200304290838.50503.josh@agliodbs.com> X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Importance: Normal X-Spam-Status: No, hits=-8.2 required=5.0 tests=BAYES_20,IN_REP_TO,NO_DNS_FOR_FROM,QUOTED_EMAIL_TEXT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/248 X-Sequence-Number: 1754 > All of the types you list were designed around the MS SQL/MSDE server > architecture, and many do not apply to PostgreSQL (for > example, Postgres does not use read locks and does not support > client-side keyset cursors as far as I know). Thanks, this backs up my feelings from some of my limited experiments with them. I guess I need to keep trying to rewrite my queries to avoid nested loops then, as this seems to be the main performance hit I get as all use indexes properly. Yours Unwhettedly, Robert John Shepherd. Editor DVD REVIEWER The UK's BIGGEST Online DVD Magazine http://www.dvd.reviewer.co.uk For a copy of my Public PGP key, email: pgp@robertsworld.org.uk