Database Profiling
Don Ignacio asked for tools to measure SQL statement execution time. Heiko Giesselmann pointed to I-Spy; Thanh noted its documentation covered only IDS 7.2, 7.3 and 8.x and asked about 9.2x. Norman Erickson Lugtu suggested timex, adding user and sys time. Art S. Kagel recommended Jonathan Leffler's sqlcmd, whose benchmark option times every command.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi All, Does anybody out there know of any tools that actually measures how long a SQL statement executes. Any help will be greatly appreciated. Don
Don, if you want detailed analysis of statement execution you should look into I-Spy: http://www.informix.com/informix/products/tools/ispy/index.html . Hope this helps, Heiko Don Ignacio wrote: > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don
In article <3A01FBE9.9CDDAFC5@informix.com>, Heiko Giesselmann <heiko.giesselmann@informix.com> wrote: > Don, > > if you want detailed analysis of statement execution you should look into I-Spy: > http://www.informix.com/informix/products/tools/ispy/index.html . The techical doc says it only supports IDS-7.2, 7.3, and 8.x What versions (1.0, 1.01, 2.0) of I-Spy will support IDS-9.2x ? Thanks, Thanh > > Hope this helps, Heiko > > Don Ignacio wrote: > > > Hi All, > > > > Does anybody out there know of any tools that > > actually measures how long a SQL statement > > executes. > > > > Any help will be greatly appreciated. > > > > Don > > Sent via Deja.com http://www.deja.com/ Before you buy.
use timex and add user + sys In article <8tsn8u$mtf$1@news.xmission.com>, Don Ignacio <dignacio@openratings.com> wrote: > > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don > Sent via Deja.com http://www.deja.com/ Before you buy.
Jonathan Leffler's sqlcmd has a benchmark option that times every command. Get it from the IIUG Software Repository. Art S. Kagel Don Ignacio wrote: > > Hi All, > > Does anybody out there know of any tools that > actually measures how long a SQL statement > executes. > > Any help will be greatly appreciated. > > Don