pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedEstimation 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