Hi.
Thanks for the proposal, but my test was with the C library, not with
ODBC as the original one. Aside from that: It's too fast. Using ODBC
only could have made it slower, so it's still to fast regardless.
Bye,
Benjamin.
On Sat, Sep 29, 2001 at 09:29:22PM -0400, [EMAIL PROTECTED] wrote:
>
> This is a guess, but I would assume that would wouldn't get accurate result
> by using ODBC.
[...]
> Just my 0.02$ worth.
> >
> > I believe you missed his point: He expected a time difference but did
> > not see any (statistically significant) differences.
> >
[...]
> > Anyhow, 1000 inserts in 0.2 seconds is about 5000 inserts per second.
> > That is much too high for forced disk writes after each insert, except
> > if you have a big RAID array, IMHO.
> >
> > I played around a bit on my testserver, a linux box with a some 2.2
> > kernel (got about 2500 inserts per second), but also got no difference
> > between flush on vs. off. A look at vmstat suggests, that the data is
> > cached and written with a delay. The delay is bigger without flush,
> > but also existent with flush. Also, the number of written blocks had
> > to be a lot bigger with flush enabled (at least 1000), but isn't.
> >
> > > On Thu, 27 Sep 2001, Meenatchi Anbuchelvan wrote:
[...]
> > > > record for each iteration. Basically I want to see how
> > > > fast the inserts are with and with out flush. I
> > > > started the mysqld in flush mode by adding an option
> > > > "flush" under the group "mysqld" in the file
> > > > /etc/my.cnf.( is the right way to start mysqld in
> > > > flush mode?, the other way of starting from command
> > > > line using flush mode didnt work for me) When I
> > > > checked the variables, I saw flush was ON. I executed
> > > > my script and saw total running time close to
> > > > 0.200-0.217 secs. I got this for several runs. Then I
> > > > removed "flush" from config file and started the
> > > > daemon. This time I expected to see much lesser total
> > > > running times. However I see times in the same range
> > > > as before.
[...]
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
