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]
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]
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
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
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
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
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
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
8 matches
Mail list logo