Results 1 to 2 of 2

Thread: MySQL query time

  1. Jun 1st, 2002, 07:23 AM #1
    ubunreal69
    ubunreal69 is offline

    Thread Starter
    Fanatic Member ubunreal69's Avatar
    Join Date
    Apr 2001
    Location
    Morayfield, Australia
    Posts
    609

    MySQL query time

    in a query, how can i find out how long the query took ?
    Reply With Quote Reply With Quote
  2. Jun 2nd, 2002, 12:39 AM #2
    JasonGS
    JasonGS is offline
    Addicted Member JasonGS's Avatar
    Join Date
    May 2000
    Location
    California
    Posts
    155
    I'm not sure in MySQL, but in code, you could do...
    Code:
    x = Now
objConn.Execute "UPDATE Mytable bla bla bla"
MsgBox "Query took " & (Now - x) & "ms."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width