RE: [sqlite] Checking out the performance of sqlite3

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

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 question

RE: [sqlite] sql query required

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

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 genre_a

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

efile to define 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 SDR

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

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?

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 sche

[sqlite] Memory and Performance Profiling of sqlite commands

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?

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: [sql

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

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

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

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

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

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 t

RE: [sqlite] Query on database operations.

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

RE: [sqlite] Query on database operations.

-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] Query on database operations.

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 where the RAM size is too small about 512kb. For that I need to tune sqlite to make its footprint, heap and stack memory as small as possible. A

[sqlite] Some Queries.

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