I had need of a programmatic interface to determine the primary keys
of a table, so I went to add it to pragma table_info, only to discover
it is already there.
The comment in pragma.c seems out of date, failing to mention the
sixth column 'pk', and so is sqlite.org/pragma.html.
--
David
Try using strace on linux. Maybe it will give you some insight to the failure.
Make sure you have enough free space on your temp dir as specified by:
PRAGMA temp_store_directory
Alternatively, if you have the memory, try:
PRAGMA temp_store = MEMORY;
and see if it behaves differently.
On Thu, 9 Nov 2006, David Gewirtz wrote:
Basically, is it bad if I decide to open and close the same database a
LOT? For example, rather than opening a database when the server boots and
keeping it open for the duration, is it bad if I open it for every query
and close it right away? I'd set
In my ongoing attempt to find the best approach for integrating SQLite into
a threaded Web-serving environment, I came upon a truly crude kludge, and I
wanted to know if it's bad from an SQLite architectural standpoint. I know
it's bad morally and ethically.
Basically, is it bad if I decide to
Preston Z wrote:
I am running into a situation where on linux (fc5 and debian3) I have
a transaction that is consistently failing using sqlite 3.3.7. The
same transaction completes on windows every time.
Some hardware information would probably help...
Martin
I am running into a situation where on linux (fc5 and debian3) I have
a transaction that is consistently failing using sqlite 3.3.7. The
same transaction completes on windows every time.
I have a large database (1.2gb) that i run a transaction on. In
windows the journal file for this transaction
- Original Message
From: Christian Smith <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, November 9, 2006 8:38:51 AM
Subject: Re: [sqlite] indexes in memory
> chetana bhargav uttered:
> > Hi,
>
> > I have a question regrading indexes,
> >
> > When I open a connection,
>
- Original Message
From: Unit 5 <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Thursday, November 9, 2006 8:02:51 AM
Subject: RE: [sqlite] Insert statement taking too long
> --- Robert Simpson <[EMAIL PROTECTED]> wrote:
> > You need to create an index on the columns you're
> >
Sqlite supports user loaded functions and triggers but not stored
procedures. You can probably achieve the functionality you need with
functions and/or triggers.
VIGNY Cecilia wrote:
Hi,
Does SQLite supports stored procedures ? If it does, what is the
appropriated syntax ?
Thanks.
Ce
Unit 5 uttered:
--- Robert Simpson <[EMAIL PROTECTED]> wrote:
You need to create an index on the columns you're
joining. Otherwise I
believe 100,000,000 rows (10k x 10k) in table 2 will
be scanned while SQLite
looks for matches against the 10,000 rows in table
1.
While that makes sense, I
chetana bhargav uttered:
Hi,
I have a question regrading indexes,
When I open a connection,
Will indexes be loaded into memory. If one of the tables in the DB, the
connection for which I have opened, has an index.
If, so is there any way to selectively load/unload that from memory.
--- Robert Simpson <[EMAIL PROTECTED]> wrote:
> You need to create an index on the columns you're
> joining. Otherwise I
> believe 100,000,000 rows (10k x 10k) in table 2 will
> be scanned while SQLite
> looks for matches against the 10,000 rows in table
> 1.
While that makes sense, I suspect
VIGNY Cecilia
wrote:
Does SQLite supports stored procedures ? If it does, what is the
appropriated syntax ?
http://article.gmane.org/gmane.comp.db.sqlite.general/16099
Igor Tandetnik
-
To unsubscribe, send email to
Hi,
Does SQLite supports stored procedures ? If it does, what is the
appropriated syntax ?
Thanks.
Ce message est protégé par les règles relatives au secret des correspondances.
Il est donc établi à destination exclusive de son destinataire. Celui-ci peut
donc contenir des informations
Hi,
I have a question regrading indexes,
When I open a connection,
Will indexes be loaded into memory. If one of the tables in the DB, the
connection for which I have opened, has an index.
If, so is there any way to selectively load/unload that from memory.
...
Chetana.
15 matches
Mail list logo