Re: [sqlite] Efficient hash lookup table emulation with SQLite - how?

2010-11-26 Thread Black, Michael (IS)
users-boun...@sqlite.org on behalf of Alexei Alexandrov Sent: Thu 11/25/2010 8:07 AM To: sqlite-users@sqlite.org Subject: EXTERNAL:[sqlite] Efficient hash lookup table emulation with SQLite - how? Hi, I'm trying to solve efficiently the following task with SQlite: * There is a trace file which

Re: [sqlite] Efficient hash lookup table emulation with SQLite - how?

2010-11-26 Thread Simon Slavin
On 25 Nov 2010, at 2:07pm, Alexei Alexandrov wrote: > * There is a trace file which contains a big number of some objects. Each > object has a number of fields which constitute its primary key (PK). > * The objects are loaded into a table which has a number of PK columns (mapped > from the

[sqlite] Efficient hash lookup table emulation with SQLite - how?

2010-11-26 Thread Alexei Alexandrov
Hi, I'm trying to solve efficiently the following task with SQlite: * There is a trace file which contains a big number of some objects. Each object has a number of fields which constitute its primary key (PK). * The objects are loaded into a table which has a number of PK columns (mapped from