On 5/31/12 8:14 PM, "Bob Sneidar" <b...@twft.com> wrote: > Foxpro does, but it's slow.
You mean that foxpro can do search on column that is not indexed ? Well, of course each db engine can do this. :-) And Valentina, and Light, and mySQL, ... And yes it is much slower than indexed search, I did mean below that everybody will enable index of a column, which is used for often searches ... So no sense mention "you can use indexes to make things faster". Everybody MUST to use indexes :-) > Bob > > > On May 31, 2012, at 9:57 AM, Ruslan Zasukhin wrote: > >>> Additionally, the structure of an SQLite DB, particularly the indexing, >>> can radically improve performance. >> >> Not very right. >> >> Any db have indexing. And relational, and navigational, and columnar. >> Nobody searches db without indexing :-) -- Best regards, Ruslan Zasukhin VP Engineering and New Technology Paradigma Software, Inc Valentina - Joining Worlds of Information http://www.paradigmasoft.com [I feel the need: the need for speed] _______________________________________________ use-livecode mailing list use-livecode@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode