on 12/28/01 19:33, diskot123 (at) juno DOT com at diskot123@juno.com wrote:
Hi Tuviah,
> BTW..in the end the valentina database with the index is 2mb smaller than
> the ascii equivelant. I'm also very happy with the speed, our app
> requires that list presented to the user be narrowed down with each
> keystroke and valentina is more than fast enough to keep up with my
> typing!
:-)
> I did a benchmark on lookup speed with LIKE and it's 3 times slower,
> which is very managable, but considering I do a sort (order by) which
> forces it to be index anyway (right?),
yes
> and it needs to keep up with the
> users typing I just went with the index. As long as we don't have to
> distribute the index with the app (which increases filesize), everything
> is great (it's all about distribution size and speed).
Yes, you must not distribute index. On first open Valentina will index all
needed fields.
> Under what circumstances does a field automatically get indexed. For
> example there is this field (varchar[205]) that I've set to be non
> indexed..and I'm not doing a lookup with it, or sorting by it, yet when I
> do a join it gets indexed (and that annoys me greatly!).
This must not happens!
Do you use this field as KEY or PTR for RDB link to do JOIN ?
> Also should I let valentina resolve references in an sql join,
> (sometable.recid = mytable.ptr), is it really smart enough to do this, and
> what is the speed difference?.
1) you can put this on Valentina only for ObjectPtr link for now.
2) there is no any speed win, just comfort for shorter query
3) If it can resolve link (ambiguity), it will give you error, so you must
for that query specify it manually
> I was working on this late last night, and oddly
> enough in a case where I resolved the join it was 20 times slower
4) You mean that if you write it manually it works slower in 20 times ?
Sounds like Valentina find way more smart that you specify, yes ?
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan (at) paradigmasoft DOT com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on@lists.macserve.net
©2001 Ruslan Zasukhin |
