Re: Speed of SQL statements

Поиск
Список
Период
Сортировка
От Mathijs Brands
Тема Re: Speed of SQL statements
Дата
Msg-id 20010223154422.B74755@ilse.nl
обсуждение исходный текст
Ответ на Speed of SQL statements  ("Kevin Quinlan" <kquinlan@computer.org>)
Список pgsql-sql
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 bookswhich are your very own".        Sir Arthur
ConanDoyle  (1859-1930)
 


В списке pgsql-sql по дате отправления:

Предыдущее
От: Mathijs Brands
Дата:
Сообщение: Re: Speed of SQL statements
Следующее
От: Tom Lane
Дата:
Сообщение: Re: insert values