Re: [sqlite] fast Java solution?

My suggestion to speed up the step call backs would be to have the JNI code do the actual step routine and cache up the pertinent information into an array. Then after it's complete or the cache limit is reached (set the cache limit to a sufficient size such that the time spent processing

[sqlite] Resources required and Lock & recovery mechanisms

Hi Everybody, I have the following doubt... 1. what are the resources required by SQLLite - they can be RAM/ROM, semaphores, mail boxes, task requirements; 2. How do we have flow control? 3. what are the Lock mechanisms provided by the engine (row lock, table lock..)? Any additional lock

Re: [sqlite] count(*)

On 7/17/06, Sripathi Raj <[EMAIL PROTECTED]> wrote: Hi, I read in one of the threads that count(*) has to be hand optimized since SQLite doesn't optimize it. Any pointers on how to do that? When doing joins put the table that contributes the smallest number of rows to the result set as the

[sqlite] count(*)

Hi, I read in one of the threads that count(*) has to be hand optimized since SQLite doesn't optimize it. Any pointers on how to do that? Raj

Re: [sqlite] timer in shell.c

Hi Brannon, Try this: SQLite version 3.3.6 Enter ".help" for instructions sql3> .help .databases List names and files of attached databases .dump ?TABLE? ... Dump the database in an SQL text format .echo ON|OFF Turn command echo on or off .exit Exit

Re: [sqlite] fast Java solution?

Brannon King wrote: Is there some standard tool that will generate a JNI dll from the sqlite.dll? Have you looked at SWIG? http://www.swig.org It doesn't generate a JNI dll from the sqlite.dll, but does generate a JNI dll from the sqlite sourcecode -- there is a learning curve, so you

[sqlite] fast Java solution?

So who here has the _fast_ Java solution for accessing SQLite3? Here's what I've done so far. I took the wrapper from wiki page labeled "Java wrapper incl. JDBC driver for SQLite. ¤http://www.ch-werner.de/javasqlite;. I then fixed the calloc calls so that the params were in the right order, fixed

Re: [sqlite] Major projects using SQLite

Jon García de Salazar Bilbao wrote: Hi, Could you give examples of some major software projects using SQLite? Kannel -- most used open source SMS and WAP gateway, http://www.kannel.org/ ;) Stipe --- Kölner Landstrasse 419 40589

Re: Re: [sqlite] Use "computed" fields to get the value of other fields.

> SELECT TotalInvoice, (SELECT SUM(PaymentValue) FROM Payments > WHERE Payments.IDInvoice = IDInvoice) AS TotalPaid, TotalPaid = TotalInvoice > AS FullyPaid FROM Invoices; > > Here, I select: > - TotalInvoice the total amount of the invoice > - TotalPaid the total amount paid till now > -

Re: [sqlite] Use "computed" fields to get the value of other fields.

On 7/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, and thanks for the reply. SELECT * from Employees where IDContractLevel > 4 is not enough, since I actually need to use a field that is created inside the SQL statement to create another field. The problem is that it seems that

Re: [sqlite] Use "computed" fields to get the value of other fields.

Hello, and thanks for the reply. SELECT * from Employees where IDContractLevel > 4 is not enough, since I actually need to use a field that is created inside the SQL statement to create another field. The problem is that it seems that the computed fields is not existing yet when it is used

Re: [sqlite] This great!

Hi, The subscribe/unsubscribe info you want is in the message headers: List-Id: SQLite Users Mailing List List-Post: List-Help: List-Unsubscribe: List-Subscribe: Regards, Martin

Re: [sqlite] This great!

I think you have an interesting idea. Split the DB across disks so concurrent activities are on different spindles, preferably at 15,000 rpm and use a multiprocessor/core cpu with the application threaded so that you deploy more than one processor concurrently. If you could be sure to

Re: [sqlite] This great!

Hi, I want to unsubscribe. Please help on this. Regards, Arif __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Re: [sqlite] This great!

Thanks Christian :D On 7/17/06, Christian Smith <[EMAIL PROTECTED]> wrote: Cesar David Rodas Maldonado uttered: > I am wondering if it will have a better performance if i split every index > and table into different files, i know that i will loose the LITE concept, > but i am wondering if it

Re: [sqlite] This great!

Cesar David Rodas Maldonado uttered: I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... Not unless each individual file is on a

Re: [sqlite] This great!

I don't know I just was wondering... but i think it will be faster if you have a really great DB and when you and insert just will be locked the table where you are doing the insert not the whole DB... what do you think?

Re: [sqlite] This great!

On 7/17/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... I doubt it,

Re: [sqlite] This great!

I am wondering if it will have a better performance if i split every index and table into different files, i know that i will loose the LITE concept, but i am wondering if it will have a better performance...

Re: [sqlite] This great!

I am wondering if it will have a better performance if i split every index and table into a file, i know that i will loose the LITE concept, but i am wondering if it will have a better performance... If you already played with pragmas you can try on windows 7-max (depends on your hardware)

Re: [sqlite] This great!

On 7/17/06, Cesar David Rodas Maldonado <[EMAIL PROTECTED]> wrote: Hello to everybody...!!! I was using my old notebook the weekend, and i was doing some programs in C to try SQLite performance, and I am happy, because i could insert 4.000.000rows in 10 minutes in my old notebook( Pentium II

[sqlite] This great!

Hello to everybody...!!! I was using my old notebook the weekend, and i was doing some programs in C to try SQLite performance, and I am happy, because i could insert 4.000.000rows in 10 minutes in my old notebook( Pentium II 400 MHZ 128 M.RAM). Thank for everybody who made it possible (share

Re: [sqlite] Use "computed" fields to get the value of other fields.

On 7/17/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Hello, everybody I'm using a SQL clause to get data from the DB, and I need to use "computed" fields to get the value of other fields. A (stupid) example of what I need is this: SELECT IDContractLevel, IDContractLevel > 4 as IAmBoss,

[sqlite] Use "computed" fields to get the value of other fields.

Hello, everybody I'm using a SQL clause to get data from the DB, and I need to use "computed" fields to get the value of other fields. A (stupid) example of what I need is this: SELECT IDContractLevel, IDContractLevel > 4 as IAmBoss, (SELECT * FROM Bosses WHERE Flag = IAmBoss) FROM

Re: [sqlite] Major projects using SQLite

Am 14.07.2006 um 15:32 schrieb Jon García de Salazar Bilbao: Could you give examples of some major software projects using SQLite? Did you check out the list at ? May not list _all_ the major projects, but sure lists quite a few...