Received: from serv1.ilse.nl (serv1.ilse.nl [212.189.131.11]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f1NEiRx45423 for ; Fri, 23 Feb 2001 09:44:27 -0500 (EST) (envelope-from mathijs@ilse.nl) Received: (from mathijs@localhost) by serv1.ilse.nl (8.11.0/8.10.2) id f1NEiMJ75370; Fri, 23 Feb 2001 15:44:22 +0100 (MET) Date: Fri, 23 Feb 2001 15:44:22 +0100 From: Mathijs Brands To: Kevin Quinlan Cc: pgsql-sql@postgresql.org Subject: Re: Speed of SQL statements Message-ID: <20010223154422.B74755@ilse.nl> References: <000001c099eb$58a5d080$79ac3318@kquinlan> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.2.5i In-Reply-To: <000001c099eb$58a5d080$79ac3318@kquinlan>; from kquinlan@computer.org on Sun, Feb 18, 2001 at 03:42:43PM -0500 X-Unexpected-Header: The Spanish Inquisition X-Archive-Number: 200102/353 X-Sequence-Number: 1549 On Sun, Feb 18, 2001 at 03:42:43PM -0500, Kevin Quinlan allegedly wrote: > 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? Performance is not easily expressed in time, since it depends a lot on the way you've setup your database and your queries (indexes, etc). Of course, the hardware you use also influences the execution time a lot. Cheers, Mathijs -- "It is a great thing to start life with a small number of really good books which are your very own". Sir Arthur Conan Doyle (1859-1930)