I have just started using SQLite and it looks great. I support it remaining small simple and correct. If it is small, then perfomance in most cases is not such an issue. I have not yet compared it to the micro db I wrote for webpage systems and will be interested to see the reults yet.
Regard the insertion efficiency. I know nothing about SQLite internals and litle about B-trees which I understand SQLite uses, but a look at Knuth provides some tweaks to the B-tree algorithms which improve performance. Mrs.Brisby suspects MySQL is packing indexes and this is the first of the refinements that Knuth mentions (AOCP Vol 2 pg 476). Regards, Paul Nash [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
