RE: [sqlite] Checking out the performance of sqlite3

2007-11-21 Thread Kalyani Tummala
Kirthana, I have done memory and performance analysis on windows, linux and other embedded platforms like Davinci,DM320,PNX0103 etc., With the same parameters memory on all the platforms is same but we cannot take performance numbers(time) on PCs(win32,linux) because they don't reflect the actual

RE: [sqlite] UI question

2007-08-02 Thread Kalyani Tummala
Simply put a ; there..it will finish the command and says invalid sqlite command and comes back to the commad mode again. -Original Message- From: Griggs, Donald [mailto:[EMAIL PROTECTED] Sent: Thursday, August 02, 2007 8:04 PM To: sqlite-users@sqlite.org Subject: RE: [sqlite] UI

RE: [sqlite] sql query required

2007-07-29 Thread Kalyani Tummala
Hi Phanisekhar Try this query.. Select yearofbirth, count(yearofbirth) from group by yearofbirth; -Original Message- From: B V, Phanisekhar [mailto:[EMAIL PROTECTED] Sent: Friday, July 27, 2007 8:31 PM To: sqlite-users@sqlite.org Subject: [sqlite] sql query required Suppose I have a

[sqlite] Integrity Check error

2007-06-06 Thread Kalyani Tummala
I was trying to insert records into sqlite database. I observed that there was a mismatch in the data retrieved. I went ahead checking for the integrity ( with PRAGMA integrity_check ) I got the following warnings: rowid 1 missing from index album_title_idx rowid 1 missing from index

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-30 Thread Kalyani Tummala
efine various sqlite compile-time flags for memory debugging. Just scan the ifdef's in the source code for ideas what to enable. It's much easier to do this under Linux than under Windows, in my opinion. --- Kalyani Tummala <[EMAIL PROTECTED]> wrote: > My temp_store is SDRAM. Thanks for your

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-30 Thread Kalyani Tummala
that approach at times. Kalyani Tummala wrote: > Hi John, > I could not understand your query properly. Let me tell you my > application scenario. > > I am planning to use sqlite as a database for storing and retrieving > media data of about 5-10k records in a device whose main memory is

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-29 Thread Kalyani Tummala
using a much smaller footprint storage system which only implements the functions you are using? Kalyani Tummala wrote: > Hi joe, > > Thanks for your response. > > In order to reduce the footprint size, I have bypassed parser completely > and using byte codes directly as my

[sqlite] Memory and Performance Profiling of sqlite commands

2007-05-29 Thread Kalyani Tummala
Dear Group, Is there any provision in the sqlite library for memory and performance profiling of SQL commands. How can I use the test folder where tcl script files are available for regression testing? How can I run those scripts in Windows XP? Thanks in advance Kalyani

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-28 Thread Kalyani Tummala
Thanks Joe, My temp_store is SDRAM. Thanks for your suggestion of using COMMIT. I have not used it. Any other pointers? Best Regards Kalyani -Original Message- From: Joe Wilson [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 10:27 AM To: sqlite-users@sqlite.org Subject: Re:

RE: [sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-28 Thread Kalyani Tummala
Hi joe, Thanks for your response. In order to reduce the footprint size, I have bypassed parser completely and using byte codes directly as my schema and queries are almost compile time fixed. Hence I am not using sqlite3_prepare(). The following is the schema and inserts I am using.

[sqlite] How to restrict the peak heap usage during multiple inserts and updates?

2007-05-28 Thread Kalyani Tummala
Dear group, I am working at porting sqlite ( ver 3.3.8 ) on an embedded device with extremely low main memory. I tried running select queries on the tables( with about 2k records each having about 5 strings) and they do well within 20kB of runtime heap usage. But, when I try new insertions,

[sqlite] using precompiled queries and turning off sql parser at compile time

2006-12-05 Thread Kalyani Tummala
Hi, In one of the group mails I have read about precompiled queries to improve the performance and reduce the foot print size and also heap size. In my application I have some fixed set of queries. Can some one point me to the sections of code that I can manipulate to do the same? Is it possible

RE: [sqlite] Query on database operations.

2006-11-30 Thread Kalyani Tummala
costly. Hence I don't think we can omit indexes. -Original Message- From: Nicolas Williams [mailto:[EMAIL PROTECTED] Sent: Thursday, November 30, 2006 8:47 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Query on database operations. On Thu, Nov 30, 2006 at 08:03:00PM +0530, Kalyani

RE: [sqlite] Query on database operations.

2006-11-30 Thread Kalyani Tummala
-compiled SQL, which means that you cannot dynamically create SQL. Kalyani Tummala wrote: > Hi, > > This mail is a bit lengthy. I thank you in advance for your patience and > help:-). > > > > Here we go.. > > > > I need to port sqlite to a platform whe

[sqlite] Some Queries.

2006-10-13 Thread Kalyani Tummala
Hello, I am a new user of this group (just joined). First of all I appreciate you for creating and maintaining such a small and robust database. I have a few simple queries on sqlite regarding footpring. I hope the owner has the answers. In sqlite features(www.sqlite.org