chetana bhargav wrote:
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
-Chetan.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 9/1/06, John Stanton wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores
Jay Sprenkle wrote:
On 9/1/06, John Stanton <[EMAIL PROTECTED]> wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores prepared statements. It has restrictions which may make it
unsuitable for general purpose applications, but could be the answer
this user is look
> I'll check my assumptions when I get some time but I thought
> interpreting an sql statement cost only a few milliseconds of time. I
> would think saving it to a rotating disk would be worse. It would cost
> on average a half disk rotation of latency to read it. Flash memory
> has no rotational
"Jay Sprenkle" <[EMAIL PROTECTED]> wrote:
> On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
> > It does make a difference with embedded deivces, where both speed and
> > memory constraints matter a lot.
>
> I'll check my assumptions when I get some time but I thought
> interpreting an sql s
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi All,
I know that we can use sqlite3_prepare, proabably my perception is wrong,
when I say sqlite3_prepare I am thinking the opcodes which ever is necessary to
run the query is created upon this call, and we can keep filling the various
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
I'll check my assumptions when I get some time but I thought
interpreting an sql statement cost only a few milliseconds of time. I
would
It does make a difference with embedded deivces, where both speed and memory
constraints matter a lot.
-Chetan.
Jay Sprenkle <[EMAIL PROTECTED]> wrote:
On 9/1/06, John Stanton wrote:
> I believe that Dr Hipp has available a special version of Sqlite which
> stores prepared statements. It
Hi All,
I know that we can use sqlite3_prepare, proabably my perception is wrong,
when I say sqlite3_prepare I am thinking the opcodes which ever is necessary to
run the query is created upon this call, and we can keep filling the various
values by just resetting the prepared statements an
On 9/1/06, John Stanton <[EMAIL PROTECTED]> wrote:
I believe that Dr Hipp has available a special version of Sqlite which
stores prepared statements. It has restrictions which may make it
unsuitable for general purpose applications, but could be the answer
this user is looking for.
For the ben
Jay Sprenkle wrote:
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi,
Is there any way to pre compile some of the prepared statements
during compile time. I am having 4 tables of which two tables doesn't
create any triggers/joins. I am basically trying to speed up the
queries on t
On Fri, 1 Sep 2006, Jay Sprenkle wrote:
The ".import" command of the command line program that comes with sqlite
works.
Thank you, Jay. I missed that.
Rich
--
Richard B. Shepard, Ph.D. |The Environmental Permitting
Applied Ecosystem Services, Inc.(TM)|Acce
On 9/1/06, chetana bhargav <[EMAIL PROTECTED]> wrote:
Hi,
Is there any way to pre compile some of the prepared statements during
compile time. I am having 4 tables of which two tables doesn't create any
triggers/joins. I am basically trying to speed up the queries on these tables
(as they a
On 9/1/06, Rich Shepard <[EMAIL PROTECTED]> wrote:
Is there a command to bulk load data (in comma and quote format) into a
table? I'd hate to copy 180 lines x 31 attributes by individually.
The ".import" command of the command line program that comes with sqlite
works. If you need something
On Fri, 1 Sep 2006, Sergio 'OKreZ' Agosti wrote:
http://www.rcs-comp.com/site/index.php/view/Utilities-SQLite_foreign_key_trigger_generator
Sergio,
Thank you. I'll need to re-do the tables now that I see that I can get the
constraints that are needed.
Rich
--
Richard B. Shepard, Ph.D.
On 01/set/06, at 15:16, Rich Shepard wrote:
Is there a way to write SQL statements that perform the same
referential
integrity checks as if foreign keys were available for constraints?
http://www.rcs-comp.com/site/index.php/view/Utilities-
SQLite_foreign_key_trigger_generator
-
I'm using sqlite3 in an application, and I think that I've read all the
docs. A search of the archives didn't reveal any threads that answer my two
questions so I'll ask them here. If there's something in the archives or a
doc that I missed, please point me to it.
Is there a way to write SQL
16 matches
Mail list logo