Re: [sqlite] Reading strings and blobs

[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

Re: [sqlite] Reading strings and blobs

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

Re: [sqlite] Reading strings and blobs

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

Re: [sqlite] Reading strings and blobs

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

Re: [sqlite] Question about sqlite TEMP table

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

[sqlite] Basic qns about TEMP table

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,

[sqlite] Question about sqlite TEMP table

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

RE: [sqlite] Multi-threading.

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. > > >

RE: [sqlite] Multi-threading.

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

RE: [sqlite] Multi-threading.

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

RE: [sqlite] Multi-threading.

> -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

Re: [sqlite] Multi-threading.

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

Re: [sqlite] Multi-threading.

- 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

Re: [sqlite] Multi-threading.

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

[sqlite] possible optimization to sqlite3BtreeMoveto

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

Re: [sqlite] optimizing database creation speed

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

Re: [sqlite] optimizing database creation speed

--- 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

Re: [sqlite] order of reception of results at the time of a request SQL

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

Re: [sqlite] order of reception of results at the time of a request SQL

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.

Re: [sqlite] order of reception of results at the time of a request SQL

> 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.

Re: [sqlite] order of reception of results at the time of a request SQL

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

Re: [sqlite] CURRENT_TIME returns false value

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

Re: [sqlite] order of reception of results at the time of a request SQL

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.

[sqlite] sqlite_busy in multithreaded application

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 and Create SQLStatement 2. Generate QueryObject 3. Query and finalize . 4.