I
> NB> have to prove that its their virus scanner that is causing the
> problems.
>
>
> NB> On 2/8/2011 1:17 PM, Jim Morris wrote:
> >>
> >> Could a backup or virus scanning software be locking the database?
> >>
> >> On 2/8
That was exactly my thought. But since it is at a customer's site, I
have to prove that its their virus scanner that is causing the problems.
On 2/8/2011 1:17 PM, Jim Morris wrote:
>
> Could a backup or virus scanning software be locking the database?
>
> On 2/8/2011 10:12 AM,
b 2011, at 5:59pm, Nathan Biggs wrote:
>
> > Once a day, not at the same time, we are getting a disk I/O error from
> > our application using SQLite.
>
> If you try to duplicate the database file do you get any kind of error
> then ?
>
> If not, use the command
Once a day, not at the same time, we are getting a disk I/O error from
our application using SQLite. Is there a more detailed way of
determining the reason of the Disk I/O error. We are running on Windows
XP. There is plenty of space on the disk (> 140GB available).
Thanks
f you were already doing the BEGIN/COMMIT.
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
>
>
> From: sqlite-users-boun...@sqlite.org on behalf of Nathan Biggs
> Sent: Fri 4/23/2010 8:05 AM
> To: General D
ring
> your inserts.
> http://www.sqlite.org/lang_transaction.html
>
> Michael D. Black
> Senior Scientist
> Northrop Grumman Mission Systems
>
>
>
>
> From: sqlite-users-boun...@sqlite.org on behalf of Nathan Biggs
> Sent: Fri 4/23
Max, thanks for the information. That will be very useful for other
table queries, but not for this one. For my table in questions there
are 18 fields. I think an index with 18 fields would be a little crazy.
On 4/23/2010 3:06 AM, Max Vlasov wrote:
>
> > ...As I add more restrictions on the
is imperative.
Having said that SQLite is light-years faster than other databases I
have used for this project. Good job to everyone who helps to support
it. Keep up the good work!
On 4/21/2010 3:28 PM, P Kishor wrote:
> On Wed, Apr 21, 2010 at 1:19 PM, Nathan Biggs<nbi...@mycfs.com&g
Is there a way to read the values of a table directly without building
and executing a query. I have a function that has predefined memory
(counters) and increments them if the data in the record matches a hard
coded value.
Since this is hard-coded, I thought it might perform much without all
=
>> From: sqlite-users-boun...@sqlite.org
>> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs
>> Subject: Re: [sqlite] Full Table Read
>>
>> We are actually using Windows XP for an OS. (I know, lots of
>> limitations, but that is what we have to u
==
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs
> Subject: Re: [sqlite] Full Table Read
>
> We are actually using Windows XP for an OS. (I know, lots of
> limitations, but that is what we ha
We are actually using Windows XP for an OS. (I know, lots of
limitations, but that is what we have to use).
Alexey Pechnikov wrote:
> Hello!
>
> В сообщении от Saturday 14 February 2009 00:33:38 Nathan Biggs написал(а):
>
>> Is there a faster way to read an
Is there a faster way to read an entire table other then:
select * from table
Not that is is slow, just curious.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Do you ever need to call finalize if prepare is not successful. Prepare
does not seem to return anything if not successful (SQLITE_OK).
___
sqlite-users mailing list
sqlite-users@sqlite.org
strcpy(rowstr, "");
i++; //increment row counter
}
//delete recordset
rc = sqlite3_finalize(ppStmt);
// close database
sqlite3_close(db);
cout << "finished" << endl;
--
*Nathan Biggs*
Computerway Food Systems
System Controls Mana
I was hoping that someone could help me with optimizing this query.
Basically I need to return totals from an large database (> 1million
records in the table). There needs to be two different totals one by
"a" and one by "b" where "a" and "b" could have up to 100 rows each. So
totals for up
Does anyone know where there is information on adding custom functions
to sqlite? I have been using the CreateAggregate function to define my
custom function, but just wanted to see if it was faster by re-compiling
sqlite with the function in it already. I have the sqlite source code
and
hello all,
I was wondering if it is possible to create an aggregate function that
uses 3 parameters in PHP. I am able to create a function that uses 1
parameter, but when I add a second one, php runs out of memory. I know
that this is probably not the place to post this, but just thought
I have been trying see just how fast I can get SQlite to run, so I have
been playing with binding data to pre-compiled statements versus having
to prepare each statement individually. So far, I have not seen a huge
performance increase between the two. I expected the pre-compiled
statements
Are you using the PDO object in PHP? If not, PHP only supports 2.8.x.
To use 3 or greater, you must use the PDO object to connect. Also make
sure that you extension is enabled for pdo_sqlite.
-Original Message-
From: Ulrich Schöbel [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 05,
That was exactly what I was looking for thanks!
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 04, 2007 6:41 PM
To: SQLite
Subject: [sqlite] Re: Math functions
Nathan Biggs <[EMAIL PROTECTED]> wrote:
> Does anyone know if there i
Does anyone know if there is a floor function in sqlite, or of a way to
implement it.
I am occasionally getting a strange behavior on one of my queries where
the sub-query is returning NULL even though the record exists.
Here is the query:
Insert into table2 values (2, (select id from table1 where x = '12345'
and y = '4567'), 0);
The record for table1 where x = '12345' and y
23 matches
Mail list logo
