On Fri, May 23, 2008 at 4:20 PM, Stefan Arentz <[EMAIL PROTECTED]> wrote:
> I have an interesting problem. I need to generate a large table
> periodically. The table contains a unique SHA1 hash code and 6 integer
> values and has about 6 million rows. Generating this table is fast. I
> can set it u
On Fri, May 23, 2008 at 10:20:45AM -0400, Stefan Arentz scratched on the wall:
> I have an interesting problem. I need to generate a large table
> periodically. The table contains a unique SHA1 hash code and 6 integer
> values and has about 6 million rows. Generating this table is fast. I
> can set
On Fri, May 23, 2008 at 3:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote:
> I'm sorry if this is an obvious question - I'm new to databases. I have
> an application where the database is used to log a large number of
> simulation events. The database is written once and read many times
> (i.e., th
On Fri, May 23, 2008 at 12:01 PM, Jeff Gibson <[EMAIL PROTECTED]> wrote:
> I'm sorry if this is an obvious question - I'm new to databases. I have
> an application where the database is used to log a large number of
> simulation events. The database is written once and read many times
> (i.e., th
On Fri, 23 May 2008 15:21:42 + (GMT), Morten wrote:
> Hi
>
> I've been puzzled for some days. I believed I had a
> hang in my system, but it turns out using the .read
> is horribly slow. I believed it to be an
> improper trigger, but removing it doesn't help a bit.
> 1min36sec to read 1000 l
I'm sorry if this is an obvious question - I'm new to databases. I have
an application where the database is used to log a large number of
simulation events. The database is written once and read many times
(i.e., there are never any inserts or updates after database creation).
The three mos
On Fri, May 23, 2008 at 4:31 AM, Christian Smith <
[EMAIL PROTECTED]> wrote:
> On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote:
> > Hi Folks:
> > I'm new to this list and just came across a major issue so I thought I'd
> > post here: I'm using SQLite (from REALbasic which uses the SQ
Hi
I've been puzzled for some days. I believed I had a hang in my system, but
it turns out using the .read is horribly slow. I believed it
to be an improper trigger,
but removing it doesn't help a bit. 1min36sec to read 1000 lines with 6 simple
columns into one table.
I know insert w
Thank you, that was immensely helpful - as well as Roger Binns many
informative posts about OpLocks.
Looks like there is nothing to be done about the slowdown (in fact I should
be grateful there is even such a thing as opportunistic locking to make the
single client situation faster), but it is a
I have an interesting problem. I need to generate a large table
periodically. The table contains a unique SHA1 hash code and 6 integer
values and has about 6 million rows. Generating this table is fast. I
can set it up in less than 90 seconds on a slow iMac (2.16 Ghz and
slow disk). The thing that
On Fri, May 23, 2008 at 12:13:39AM -0700, Roger Binns scratched on the wall:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> sqlite wrote:
> > our workaround to move backwards is optimistic. if some one could help me in
> > this regard, if could share some code for moving backwards it would
On Tue, May 13, 2008 at 11:15:51PM -0600, Peter K. Stys wrote:
> Hi Folks:
> I'm new to this list and just came across a major issue so I thought I'd
> post here: I'm using SQLite (from REALbasic which uses the SQLite DB engine
> for SQL support) to store image files, and while R/W to local files i
Hi all,
Scott Baker wrote:
> As mentioned above the BEST way to do it is with prepared statement
> and bound variables. If you have to use raw SQL then just use the
> PDO::quote method:
>
> http://php.web-ster.com/manual/en/pdo.quote.php
>
> $conn = new PDO('sqlite:/home/lynn/music.sql3'); $stri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sqlite wrote:
> our workaround to move backwards is optimistic. if some one could help me in
> this regard, if could share some code for moving backwards it would be more
> helpful to me.
http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
Roger
---
Dear All,
i have developed an application using SQLite which runs in the pocket pc
device. My application has to show some messages in a list box (custom
build) while moving forward im able to move the records one by one in the
recordset. But when i move upwards im not able to move to the corresp
15 matches
Mail list logo