Re: [sqlite] external indexing

2006-05-30 Thread Rusty Conover
On May 30, 2006, at 3:05 AM, Noel Frankinet wrote: Hello Rusty, Exactly what I was looking for I've seen the PRAGMA TEMP_STORE to create a memory table. Do you think I can join a memory table and a disk based one ? Anyway, thank a lot Best wishes Of course you can do that. Rusty --

Re: [sqlite] external indexing

2006-05-30 Thread Rusty Conover
e. Finally don't forget to: DROP TABLE search_keys Cheers, Rusty -- Rusty Conover InfoGears Inc. Web: http://www.infogears.com

[sqlite] Rule of thumb for estimating index size

2006-04-21 Thread Rusty Conover
that close? I realize disregards all space used by page allocation overhead. Thanks, Rusty -- Rusty Conover InfoGears Inc.