Upgrade to Lion -- why Valentina has columnar format ...

Ruslan Zasukhin ruslan_zasukhin at valentina-db.com
Thu May 31 14:19:46 EDT 2012


On 5/31/12 8:14 PM, "Bob Sneidar" <bobs at 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]






More information about the Use-livecode mailing list