Performance SQL

Posted in 2006

Demeis, Tony — Thu, 15 Jun 2006 13:35:42 — source: IIUG Forums & Mailing Lists

Hi, Does anyone have some SQL that can provide basic average query response time data. Thank you. Tony

↪ replying to Demeis, Tony

ART KAGEL, BLOOMBERG/ 731 LEXIN — Thu, 15 Jun 2006 13:41:48 — source: IIUG Forums & Mailing Lists

There's no such thing. Average response time for what? A server connection? Opening a database after connection? Connect and open database together? A single table SELECT? A two table join - via index - with no index? An N table join? An outer join? Between small tables? Between large tables? Between tables of vastly differing sizes? Your question is meaningless. You have to benchmark your own application needs. If you cannot do that with an actual database you need to build a benchmark database that will behave similarly. Any benchmarks I have will be useless to you. Art S. Kagel ----- Original Message ----- From: Tony Demeis <ids@iiug.org> At: 6/15 9:39:32 Hi, Does anyone have some SQL that can provide basic average query response time data. Thank you. Tony ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum.