[23-07-2005 1:29, D. Richard Hipp escreveu]
On Fri, 2005-07-22 at 19:15 -0500, Shawn Walker wrote:
Is there a way to have sqlite to call a callback function to read in
strings and blobs?
No.
If your blobs are too big to fit in memory, perhaps you should
consider storing them each in a separ
D. Richard Hipp wrote:
On Fri, 2005-07-22 at 19:15 -0500, Shawn Walker wrote:
Is there a way to have sqlite to call a callback function to read in
strings and blobs?
No.
If your blobs are too big to fit in memory, perhaps you should
consider storing them each in a separate file and then st
If your blobs are too big to fit in memory, perhaps you should
consider storing them each in a separate file and then store
just the filename in the database.
That assumes you have a filesystem :-) I too would like random
access to strings and blobs (especially the latter). In many
cases isn't
On Fri, 2005-07-22 at 19:15 -0500, Shawn Walker wrote:
> Is there a way to have sqlite to call a callback function to read in
> strings and blobs?
No.
If your blobs are too big to fit in memory, perhaps you should
consider storing them each in a separate file and then store
just the filename in
Is there a way to have sqlite to call a callback function to read in
strings and blobs? What I mean is that we have some very large data and
rather not consume all those memory, so what I want to do is pass a user
defined pointer that contains a pointer to a file handle (as an example)
and tha
On Fri, 2005-07-22 at 19:44 -0300, Ming Qiang Lin wrote:
> It says that temp table is visible to the process it created, but how
> about in this same process, I join a temp table with non-temp table?.
> Since I am having Exception says: "no such table" when I do the join.
>
The text is wrong and
I forgot to mention, I do have two connections in ONE process, one of
the connection is used to create those temp tables. but still, after
temp table is created, none of the two connection can access to the
Temp tables.
On 7/22/05, Ming Qiang Lin <[EMAIL PROTECTED]> wrote:
> Hi All,
>
> Following
1) When I want to move/insert records from a TEMP table into my
regular table, can I do this within a transaction?
2) Suppose my Table/(and Temp Table) have a schema like
CREATE [TEMP] TABLE My[Temp]Test (
id primary key not null,
value int);
and I use insert into MyTest(null, {intvalue}
Hi All,
Following is the sqlite CREATE TABLE definition:
If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and
"TABLE" then the table that is created is only visible to the process
that opened the database and is automatically deleted when the
database is closed. Any indices create
On Fri, 2005-07-22 at 17:23 -0400, D. Richard Hipp wrote:
> On Fri, 2005-07-22 at 14:00 -0700, Tim McDaniel wrote:
> > It is hard, if not impossible, with modern GUI
> > systems to write any relatively complex app that is both performant and
> > graphically responsive without using threads.
> >
>
On Fri, 2005-07-22 at 14:00 -0700, Tim McDaniel wrote:
> > History has demonstrated that programmers building
> > multithreaded applications tend to produce buggier code, and
> > code that touches more pages than a non-threaded version. As
> > a result, the non-threaded version is easier to writ
On Fri, 2005-07-22 at 14:00 -0700, Tim McDaniel wrote:
> It is hard, if not impossible, with modern GUI
> systems to write any relatively complex app that is both performant and
> graphically responsive without using threads.
>
Not true.
The event model works just fine for GUI programming.
The b
> -Original Message-
> From: Mrs. Brisby [mailto:[EMAIL PROTECTED]
> Sent: Friday, July 22, 2005 3:07 PM
> To: sqlite-users@sqlite.org
> Subject: Re: [sqlite] Multi-threading.
>
> > However the need for multi-threads is compelling.
> Especially in a GUI
> > environment. For instance a
On 7/22/05, Paul G <[EMAIL PROTECTED]> wrote:
> > Using Exceptions correctly, I have never felt the need for a GoTo.
> > Exceptions do the same as GoTo, accept, maybe, in a slightly more
> > developed and useful way.
>
> then you haven't coded anything complex enough to require them. i can tell
>
- Original Message -
From: "Ben Clewett" <[EMAIL PROTECTED]>
To:
Sent: Wednesday, July 20, 2005 12:26 PM
Subject: Re: [sqlite] Multi-threading.
> Dr Hipp,
>
> I am just playing devils advocate here because I have completed much
> Java programming in a multi-threaded application. :)
>
>
On Wed, 2005-07-20 at 17:26 +0100, Ben Clewett wrote:
> Dr Hipp,
>
> I am just playing devils advocate here because I have completed much
> Java programming in a multi-threaded application. :)
>
> I understand the problems of multi-threading. I am reminded that it
> took nearly 20 years of devel
I've been working with SQLite 3.2.1 and trying to do database creation
as fast as possible. In my situation, I've been using auto-incremented
key values. One thing that I've noted is that a fair amount of time was
being spent in sqlite3BtreeMoveto(). As I understand it, the general
algorithm
My data types are similar to those in your example. Using the
suggestions on your page, I was able to increase performance a fair
bit. I'm able to get near 240,000 inserts/second on my 3GHz Xeon Linux
system with your example program.
I did find a place for optimization in the btree code whi
--- Al Danial <[EMAIL PROTECTED]> wrote:
> On 7/21/05, Chuck Pahlmeyer - MTI <[EMAIL PROTECTED]>
> wrote:
> > I have an application in which I'd like to create a
> database as
> > quickly as possible. The application has a batch
> process at
> > startup which creates the data. I am using a singl
On 7/22/05, LURKIN Denis <[EMAIL PROTECTED]> wrote:
> I have do many tests. It appears that the results of requests
> each time are received in the same order. This order is that of
> creation of the table. If I have make a CREATE TABLE X (int, char,
> int, char), I receive the results of my reques
Thank you to all, I thus will pay attention in my code and to put the
columns in the order and thus not to use the "select *". It will
be more careful.
Denis Lurkin.
> I have do many tests. It appears that the results of requests
> each time are received in the same order. This order is that of
> creation of the table. If I have make a CREATE TABLE X (int, char,
> int, char), I receive the results of my request SQL in the good order:
> int, char, int, char. How
On 7/21/05, Neelamegam Appadurai <[EMAIL PROTECTED]> wrote:
> Hi,
> Though they were lot of discussion on this, I could not find solution
> in my case. To elaborate the happening.
> Let me say i have two threads
> 1.ReadThread
> 2. DeleteThread
>
> My ReadThread does the following.
> 1. Compile an
I have created a small 4 column d-base and if I do a "select * from table"
sqlite always returns to me the order of the data in the order that it was
listed in the create statement. (Actually, I based a lot of functionality in a
small C++ program I wrote on this, and it has never failed. I've
On Jul 22, 2005, at 2:11 AM, LURKIN Denis wrote:
Hello,
I have do many tests. It appears that the results of requests
each time are received in the same order. This order is that of
creation of the table. If I have make a CREATE TABLE X (int, char,
int, char), I receive the results of my reque
Why didn't I think to it ?
thanks sqlite-users :-)
Selon Joseph Bruni <[EMAIL PROTECTED]>:
> whalesong:~ brunij$ date
> Thu Jul 21 13:40:42 MST 2005
> whalesong:~ brunij$ sqlite3 /dev/null 'select current_time'
> 20:40:44
>
>
> It works for me. I'm located at GMT-7. Where are you?
>
> Perhaps
Hello,
I have do many tests. It appears that the results of requests
each time are received in the same order. This order is that of
creation of the table. If I have make a CREATE TABLE X (int, char,
int, char), I receive the results of my request SQL in the good order:
int, char, int, char. Howe
27 matches
Mail list logo
