Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id f1N2ebx52115 for ; Thu, 22 Feb 2001 21:40:37 -0500 (EST) (envelope-from pgsql-sql-owner@postgresql.org) Received: from smtprelay1.adelphia.net ([64.8.25.6]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1IKllx63667 for ; Sun, 18 Feb 2001 15:48:56 -0500 (EST) (envelope-from kquinlan@computer.org) Received: from kquinlan ([24.51.172.121]) by smtprelay1.adelphia.net (Netscape Messaging Server 4.15) with ESMTP id G8Z09K00.FLG for ; Sun, 18 Feb 2001 15:44:08 -0500 From: "Kevin Quinlan" To: Subject: Speed of SQL statements Date: Sun, 18 Feb 2001 15:42:43 -0500 Message-ID: <000001c099eb$58a5d080$79ac3318@kquinlan> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook CWS, Build 9.0.2416 (9.0.2910.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Disposition-Notification-To: "Kevin Quinlan" X-Archive-Number: 200102/344 X-Sequence-Number: 1540 Does anyone have any performance numbers regarding SQL statements, specifically SELECT, UPDATE, DELETE, and INSERT? For instance, on average how long does a typical SELECT (UPDATE, DELETE, INSERT) statement take to execute? Thank you, Kevin