Re: [sqlite] How to unsubscribe from his group?

Did you bring any food? I got a soda. *Note this response may contain mild humor, satire, half truths, and material which may be insulting to tech-people. Do not take seriously. mos <[EMAIL PROTECTED]

[sqlite] How to unsubscribe from his group?

I've sent half a dozen emails to this address "[EMAIL PROTECTED]" over the past few days and I'm still getting email. Is there a trick to it? Mike - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] [Visual Basic] How do you work with SQLite?

At 05:25 PM 8/9/2007, you wrote: I use it mainly to manipulate data obtained from an Interbase database. All the data will eventually be dumped to Excel. I use 2 ways to move data from Interbase to SQLite. One, via an ADO recordset after connecting to Interbase with ODBC. This recordset will

Re: [sqlite] Creating index takes over an hour

At 01:42 PM 8/9/2007, you wrote: --- mos <[EMAIL PROTECTED]> wrote: > Is there no way to allocate more memory to SQLite index buffers like you > can with MySQL and most other databases? I suspect SQLite is building the > index on disk which will be 100x slower than if it used RA

Re: [sqlite] Creating index takes over an hour

At 12:10 PM 8/9/2007, you wrote: > > > cat your.db > /dev/null > > > > > Using Windows XP. :-0 > > Anyone know a simple Windows command line equivalent of the cat > to dev null command above to put a file into OS cache? Well, 'type your.db > nul' will do the same thing, though whether or not

Re: [sqlite] Creating index takes over an hour

ttp://www.sqlite.org/pragma.html Using Windows XP. :-0 Mike --- mos <[EMAIL PROTECTED]> wrote: > I'm building my first index on a large table using the "Create index > ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so > far it has been running ove

[sqlite] Creating index takes over an hour

I'm building my first index on a large table using the "Create index ix_Main on Table1(StringField1,StringField2,DateField,TimeField)" and so far it has been running over an hour on a fast computer with 2gb ram. There are 15 million rows in the table. The same index can be built in MySQL in a

[sqlite] New User: Creating/Modifying tables

I created my first Delphi program with DISQLite3 1.40 and I used the Importer component to create the table and I imported a few of the rows from MySQL 5. The problem is the dates in the SQLite table show up as floating point, which is how they are natively stored. 1) How can I determine what