> Thanks for the link. But InnoDB uses the same basic architecture > as SQLite. So this does not explain why performance drops off > on SQLite but not on InnoDB. > > Still looking....
Does SQLite perform this InnoDB optimization? "Dirty (changed) database pages are not immediately sent to the operating system to be written by InnoDB, which can make it substantially faster than MyISAM in some situations." The O_DIRECT flag Richard Dale mentioned is very interesting: http://www.ukuug.org/events/linux2001/papers/html/AArcangeli-o_direct.html in particular this graph comparing O_DIRECT use versus not using it in a self-caching DB application: http://www.ukuug.org/events/linux2001/papers/html/o_direct.png __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com