I used the SQLite BTree for indexing. If you are doing complex query, I think you are much better off with SQL... The btree API is undocumented (documented somewhat in the source files) and unsupported. If you are gonna do that, I had recently posted some problems/solutions I encounter using the Btree library. I also think it does not support duplicate keys... I am not too sure so I program around it to make the key unique. Honestly I think I was lucky to got it working to the way I want it. I really appreciated all the self-less efforts people put into SQLite and therefore still receiving this newsletter and keep an eye on it. :-)
-----Original Message----- From: Cesar David Rodas Maldonado [mailto:[EMAIL PROTECTED] Sent: Thursday, August 24, 2006 1:41 PM To: sqlite-users@sqlite.org Subject: [sqlite] Btree Hello to everyone. I want to ask something for the people who made SQLite. Every Index in a table is a Btree? So is the a manual of how can I use the SQLite Btree algorithm for my own? And if I use the Btree will be faster than use SQLite? because SQLite need to understand the SQL and I think that took time... if the query is complex Thank ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
