I too cannot get the site correctly.  

I am using IE.  If I wait long enough (about 2 min) text will appear but
the images never seem to make it.

Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O:  (512) 248-2287
M:  (713) 252-4688

-----Original Message-----
From: Andy Eastham [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 10:12 AM
To: Mysql List
Subject: RE: BETWEEN

Max,

You can measure the elapsed time by writing a linux shell script to do
the
inserts, then use the linux "time" command to run it. However, the user
and
system times displayed will not include the amount of cpu time used by
the
db server.

Do it a few times and vary the number of inserts to build an accurate
picture.

Alternatively, you may be able to do this easier in version 4.1, where
you
can use %f in time_format to get milliseconds, so hopefully now()
retrieves
milliseconds too(?): select time_format(now(), '%H:%i:%s.%f'); to get
timestamps to the nearest millisecond.  Of course, getting the timestamp
takes a finite amount of time, which you may want to measure.

Andy

-----Original Message-----
From: Boyd E. Hemphill [mailto:[EMAIL PROTECTED] 
Sent: 20 April 2004 14:29
To: 'Max Michaels'; 'mysql'
Subject: RE: BETWEEN

Max:

Thanks for the tip.

Unfortunately I am not using a FreeBSD environment.  My options are to
either run a WinXP client remotely or to run something Linux based in a
terminal emulator (Putty).

Any suggestions would be appreciated.


Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.
www.triand.com
O:  (512) 248-2287
M:  (713) 252-4688

-----Original Message-----
From: Max Michaels [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, April 20, 2004 7:07 AM
To: 'Boyd E. Hemphill'; 'mysql'
Subject: RE: BETWEEN

>
>Hello:
>
>I am trying to measure the difference between a single insert statement
of
10,000 rows and 10,000 insert statements.
>
>It is easy for me to see the single statement takes about 2 seconds.
>However I can come up with no good way to get the total time for
individual
statements.  
>
>Can anyone provide a suggestion?  Thanks in advance.


 Try super-smack. It works great for this type of testing.
http://jeremy.zawodny.com/mysql/super-smack/



>Best Regards,
>Boyd E. Hemphill
>[EMAIL PROTECTED]
>Triand, Inc.
>www.triand.com
>O:  (512) 248-2287
>M:  (713) 252-4688
>
>
>
>--
>MySQL General Mailing List
>For list archives: http://lists.mysql.com/mysql
>To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to