Updating record takes seconds

[Ruslan Zasukhin]

On 2/20/12 12:30 PM, "Beatrix Willius" <bwillius at gmx.de> wrote:

Hi Beatrix,

> The index was the problem. However, re-indexing in Realbasic still makes the
> app unresponsive.
> 
> It now takes 3 minutes for adding 7000 or so records

Without indexes ???

Somehow not fast ...

Without blobs, without indexes table with 19 fields,
make 100K inserts in about 3 seconds.

Not sure how blobs slow down ...

May be you insert big enough BLOBs (e.g. 5-10KB) but have too small segment
(e.g. 128 bytes), so you get long segment chains inside of a BLOB value ...
Then try make it 1024 bytes to see if this helps ...



> and 7 minutes for the
> index.

May be you have small cache size?
    try make it 10-20-30Mb.

 
> Do like or regex searches use IndexByWords?

ONLY   LIKE users  and only if you have patter START WITH

    f LIKE 'StartOfStr%'




-- 
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]