pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Estimation of SQL statements
2+ messages / 2 participants
[nested] [flat]

* Estimation of SQL statements
@ 2001-02-18 21:11 Kevin Quinlan <kquinlan@computer.org>
  2001-02-24 11:23 ` Re: Estimation of SQL statements Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Kevin Quinlan @ 2001-02-18 21:11 UTC (permalink / raw)
  To: pgsql-sql

Are there any good techniques that estimate the time it will take to execute
an SQL statement, specifically an INSERT, SELECT, UPDATE, or DELETE?  What
factors are important to consider when estimating the execution time of
these types of SQL statements?
Thank you,
Kevin





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Estimation of SQL statements
  2001-02-18 21:11 Estimation of SQL statements Kevin Quinlan <kquinlan@computer.org>
@ 2001-02-24 11:23 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2001-02-24 11:23 UTC (permalink / raw)
  To: Kevin Quinlan <kquinlan@computer.org>; +Cc: pgsql-sql

Kevin Quinlan wrote:
> 
> Are there any good techniques that estimate the time it will take to execute
> an SQL statement, specifically an INSERT, SELECT, UPDATE, or DELETE?  What
> factors are important to consider when estimating the execution time of
> these types of SQL statements?
> Thank you,
> Kevin

Complexity and size of statement, complexity and size of tables
involved, complexity and size of indices involved, amount of data (if
any) returned, RDBM design and implementation consideration, OS,
hardware, hardware loading, client design...

Really, you need to know what you are trying to acheive. The best way to
measure speed is to build a system and populate it with dummy data.
Then, analyse your results.

- Richard Huxton



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-02-24 11:23 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-18 21:11 Estimation of SQL statements Kevin Quinlan <kquinlan@computer.org>
2001-02-24 11:23 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox