[sqlite] SQLite and OS/2

Hallo, i want to Port an Linux/Windows Application (mailfilter) which is usingSQLite as an backend to OS/2. Does anyone know, whether there is a Port of Sqlite to OS/2? The DOS32-Port of SQLite is not sufficient because of the missing lfn- support. Thanks Hans-Juergen Gruss Hans-Jürgen -

Re[2]: [sqlite] Performance problem

> If you disable idx2, you will see that the inserts go much faster. I > also observe that the journal file is about 1/3rd the size of the database, > which is consistent with the observation that every disk block associated > with idx2 needs to be changed. My TCL test script for this situation >

Re: [sqlite] Performance problem

Avner Levy wrote: Hi, I've written the following program to test the sqlite performance for a specific scenario I have. I've used most tricks I've found but still when the database gets big the performance gets unacceptable. The performance problem happens of course only if the indexes are define

[sqlite] Fields parameters

Hi, I've got a question, how could I get the field parameters (e.g. id is integer and not null) I know that there is create table statment in SQLITE_MASTER for each table, but I want to use sqlite in program language there is no regular exp. in so it is hard to parse this statement, I'm looking for

[sqlite] Performance problem

Hi, I've written the following program to test the sqlite performance for a specific scenario I have. I've used most tricks I've found but still when the database gets big the performance gets unacceptable. The performance problem happens of course only if the indexes are defined. Since I need th