On 9/4/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote:
What i meaning how sqlite do for search b-tree indexs? the index are copy to main memory or the merge is done just in hard disk search for every item? understand my question?
Sqlite indexes may be cached by the operating system depending on the size of the index and the size of the computer's RAM. If you don't have a huge database it will probably be cached. In general sqlite performs as well as the other databases and in a lot of cases better. That depends on the programmer being able to optimize his database design, just as with any other database. The sqlite mailing list has been a very good resource for getting help. A lot of very talented people hang out here. ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
