Re: Query's Speed

2002-04-05 Thread Lance Uyehara
> in perl: [very simple code] > > my $stime = time; > > prepare(); > execute(); > fetchall_array_ref(); > > my $etime = time; > > my $ftime = $etime - $stime; > > print "Your query took $ftime seconds\n"; > > stupid filter: sql, query, mysql, db, table, select, insert, update, delete, > join, crea

Re: Query's Speed

2002-04-05 Thread Lucas Marinho Saud
hi, in perl: [very simple code] my $stime = time; prepare(); execute(); fetchall_array_ref(); my $etime = time; my $ftime = $etime - $stime; print "Your query took $ftime seconds\n"; stupid filter: sql, query, mysql, db, table, select, insert, update, delete, join, create, left join, optimi

Query's Speed

2002-04-04 Thread Ronnie Alfaro
Hi there, Lets say i do the following query: mysql > select something from some_table; Then i will get the results , how many rows and how much time it took to perform the query. My question is how can i get the time it took for perform the query. I want that cuz i would like to put in a web pag