Re: [sqlite] fast Java solution?

2006-07-17 Thread Vitali Lovich
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

2006-07-17 Thread Vivek R
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(*)

2006-07-17 Thread Jay Sprenkle
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(*)

2006-07-17 Thread Sripathi Raj
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

2006-07-17 Thread carl clemens
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?

2006-07-17 Thread Ulrik Petersen
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] timer in shell.c

2006-07-17 Thread Brannon King
I'd like to modify the shell.c so that I get an "time taken" output with each query executed (similar to the mysql client). Where would I put the start and stop/print code in shell.c so that I capture the query time but not the time required to output the data to the console? Thanks.

[sqlite] fast Java solution?

2006-07-17 Thread Brannon King
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

2006-07-17 Thread Stipe Tolj
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.

2006-07-17 Thread Brad Stiles
> 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.

2006-07-17 Thread Jay Sprenkle
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.

2006-07-17 Thread elemaco71-sqlite
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!

2006-07-17 Thread Martin Jenkins
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!

2006-07-17 Thread John Stanton
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!

2006-07-17 Thread Mohammad Shiful Islam
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!

2006-07-17 Thread Cesar David Rodas Maldonado
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!

2006-07-17 Thread Christian Smith
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!

2006-07-17 Thread Cesar David Rodas Maldonado
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!

2006-07-17 Thread Jay Sprenkle
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!

2006-07-17 Thread Cesar David Rodas Maldonado
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!

2006-07-17 Thread Eduardo
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!

2006-07-17 Thread Jay Sprenkle
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!

2006-07-17 Thread Cesar David Rodas Maldonado
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.

2006-07-17 Thread Jay Sprenkle
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.

2006-07-17 Thread elemaco71-sqlite
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

2006-07-17 Thread Jens Miltner
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...