Hi

i have a editable browse TDbgrid , with 15'000 records.
I'm using a TDbIsamTable with 5 field in fkLookup in a very small table ,
and 1 field in fkLookup in a table with 1000 records.

Open. , close, insert.. function on this table is VERY SLOW ( 10 sec. to
close table )

No calcfield
No afterscroll......
No filter
No range..
No code...

SPEED :

old application with BDE :  ULTRA FAST
Dbisam 4.9 and 4.19 is Medium Fast : 2 sec. to enter ,2 to close , 1 to
insert record.
but
4.22 is Slow :    15 to enter enter , 30 sec. to close, ( 1 minute to close
table on network disk )


the problem in on the lookup on 1000 records table ( it's is VISIBLE = FALSE
, too )

i have remove this field , and now is fast like 4.19.......

i have try LookupCache, but notting.

Why ?   dbisam read 15'000 * 1000 time all records ?
Hint for have a dbgrid with any fkLookup in fast mode ?

Antony Miller wrote:

> Open. , close, insert.. function on this table is VERY SLOW ( 10 sec.
> to close table )

It would help if you would describe if you are accessing local data or
server data and if you are using C/S or not.


--
David Farrell-Garcia
Whidbey Island Software LLC

Posted with XanaNews 1.17.6.6

Antony,

<< Why ?   dbisam read 15'000 * 1000 time all records ? Hint for have a
dbgrid with any fkLookup in fast mode ? >>

Does the lookup table have a case-insensitive or case-sensitive index on the
column that is being referenced in the lookup ?  The case-sensitivity of the
index must match or else the lookup will resort to a brute-force search.

--
Tim Young
Elevate Software
www.elevatesoft.com