[sqlite] Heap Memory usage in Sqlite

2007-12-17 Thread Sreedhar.a
Hi, I am working with the database of 40k records. My database table contains the metadata information of audio files. When I searched for the first 50 records, the heap usage is small. when I searched for the last 50 records, the heap usage is almost equal to searching the entire database

Re: [sqlite] Skype client using SQLite?

2007-12-17 Thread Kees Nuyt
On Tue, 28 Aug 2007 15:13:47 +, [EMAIL PROTECTED] wrote: >In reference to > > http://www.sqlite.org/cvstrac/tktview?tn=2592 > >This is the first public indication we have had that >Skype is using SQLite in their windows clients. However, >the person who wrote the ticket seems to be a bit

Re: [sqlite] Running multiple SQLite processes

2007-12-17 Thread kenmor
Hi Everyone, The problem was a mix of processes running SQLite 3.5.3 and 3.3.12. When all processes ran 3.5.3 the problem disappeared and we got a consistent high performance (<4ms per select). Regards Ken kenmor wrote: > > > Hi Everyone, > > We are seeing the following strange behaviour

Re: [sqlite] Heap Memory usage in Sqlite

2007-12-17 Thread Kees Nuyt
On Mon, 17 Dec 2007 17:34:26 +0530, "Sreedhar.a" <[EMAIL PROTECTED]> wrote: >Hi, > >I am working with the database of 40k records. >My database table contains the metadata information of audio files. > >When I searched for the first 50 records, the heap usage is small. >when I searched for the

[sqlite] Multiple connections and triggers

2007-12-17 Thread Prakash Reddy Bande
Hi, I am in a situation where-in there are multiple connections to a single sqlite database. When one connection updates the database other connections would like to get the information about the change (asynchronously, for example when user wants he will use some refresh like command of the

Re: Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-17 Thread Ken
Ion, I second your comments. Personally, I think Encirq is wasting everyones time cluttering the sqlite mailing list with propaganda. Not an ideal way to gain trust or customers. I preffer the open and honest style of DRH. I also think its rude that they do this on a sqlite mailing list.

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
Hi All, I have two question regarding DATETIME column data type: 1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier if this column type is INTEGER vs DATETIME then do the conversion in the GUI code to convert from INTEGER TO DATETIME. 2) And if I store as

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Lynn Fredricks
> Keeping the discussion academic, "hype a product..." is a > business model that apparently has been used to at least some > degree by a company called Microsoft. It tends to work > because the model permits them such an early lead that even > better products have difficulty catching up. >

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread John Stanton
If you declared your date and time (timestamp) column DATETIME it will be floating point and will store date and time in 8 bytes. Use the FP bind function. If you make it a REAL instead of DATETIME your code will be clearer. Joanne Pham wrote: Hi All, I have two question regarding DATETIME

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
Thanks John, " If you make it a REAL instead of DATETIME your code will be clearer." So you meant that I should make my datatype as REAL instead of DATETIME. Thanks, Joanne - Original Message From: John Stanton <[EMAIL PROTECTED]> To: sqlite-users@sqlite.org Sent: Monday, December

RE: Re[2]: [sqlite] Improving performance of SQLite. Anyone heard of DeviceSQL?

2007-12-17 Thread Tom Briggs
> As my father was fond of saying; "Money talks and BS walks." Unfortunately, that rule is decidedly invalid in the commercial software world. Bear in mind that DRH doesn't sell software, which is part of the reason why he and Encirq go about doing things differently. -T

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Dennis Cote
Joanne Pham wrote: I have two question regarding DATETIME column data type: 1 ) Should I store my COLUMN as INTEGER instead of DATETIME. Is it easier if this column type is INTEGER vs DATETIME then do the conversion in the GUI code to convert from INTEGER TO DATETIME. 2) And

[sqlite] table.* excludes ID field when using natural join ?

2007-12-17 Thread Samuel R. Neff
I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for instructions sqlite> create

[sqlite] Sqlite in Python on Bluehost Web hosting

2007-12-17 Thread Shawn Milochik
I searched the archives, but couldn't find a way to fix this on my own. I use Bluehost.com for Web hosting. I like Python. I like Sqlite. I'm trying to use the three together. Bluehost supports Python, and sqlite is installed. I have ssh access. However, there is no pysqlite2 or apsw support

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread John Stanton
Sqlite stores a date and time as a REAL so instead of trusting to manifest typing to make it a REAL your code will be easier to follow if you declare it a REAL. Here is a simple list of the date and time functions embedded in Sqlite 1. date( timestring, modifier, modifier, ...) returns

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff from the largest pool, not the most effective. Besides it's damn hard to be a

Re: [sqlite] table.* excludes ID field when using natural join ?

2007-12-17 Thread Dennis Cote
Samuel R. Neff wrote: I would expect "SELECT T.*" to always return all fields from table T. However this seems not to be the case when using natural join. Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\>sqlite3 SQLite version 3.4.2 Enter ".help" for

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread epankoke
Wow, I know this isn't really the point of your comment, but I always have to jump in when I see VB programmers "attacked". So as a Delphi / C++ / VB programmer, where do I fit into your analogy? Do I end up replacing myself :) -- Eric Pankoke Founder / Lead Developer Point Of Light Software

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Joanne Pham
Hi John, Thanks for the detail info. I am still very new to SQLite3 and sorry for the question. My application is used C++ to insert/select the data from this table. So if I defined it as create table mytable ( createDate REAL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (remoteWXId) );

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread James Steward
On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: > A hundred or so Visual Basic programmers are cheaper to replace and > "maintain" than one good Delphi/C++ programmer. ;-) That is the reason > management likes "Visual ." Been there, learned that. Hire the > staff from the largest

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread Dennis Cote
Joanne Pham wrote: My application is used C++ to insert/select the data from this table. So if I defined it as create table mytable ( createDate REAL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (remoteWXId) ); Then I can use sqlite3_bind_real to bind the column but what is the

[sqlite] RE: Visual Studio (was Improving performance of SQLite)

2007-12-17 Thread Robert Simpson
I was a die-hard Amiga programmer years ago and swore never to put a PC on my desk at home. Unfortunately they used them at work, so I was forced to learn it. After a few years of being a broke enthusiast on the Amiga, I wrote a business app on the PC in Visual C and VB3. It was my first

RE: [sqlite] Improving performance of SQLite. Anyone heard of Devic eSQL?

2007-12-17 Thread Fred Williams
I doubt it, you are obviously aggressive enough to learn more than the Mickysoft studio. Honestly, how many Visual X programmers do you know that have come from the "rank and file?" As a consultant, I have seen a very large proportion who have. I admire anyone who has the desire and

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevic eSQL?

2007-12-17 Thread John Elrick
James Steward wrote: On Mon, 2007-12-17 at 15:30 -0600, Fred Williams wrote: A hundred or so Visual Basic programmers are cheaper to replace and "maintain" than one good Delphi/C++ programmer. ;-) That is the reason management likes "Visual ." Been there, learned that. Hire the staff

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread John Elrick
John Elrick wrote: SNIP When you can hire a forklift operator to program (well, that is), To avoid a misunderstanding...I mean - right off the forklift. I'm sure anyone with the proper motivation can learn to program, but it took me 25 years to realize how little I really knew. John

Re: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread James Steward
On Mon, 2007-12-17 at 19:22 -0500, John Elrick wrote: > John Elrick wrote: > > SNIP > > When you can hire a forklift operator to program (well, that is), > > > To avoid a misunderstanding...I mean - right off the forklift. I'm sure > anyone with the proper motivation can learn to program, but

Re: [sqlite] Improving performance of SQLite. Anyone heardofDevice SQL?

2007-12-17 Thread John Elrick
I didn't write the original about forklift operators. It was Fred Williams, AFAIK. It was. SNIP IMHO, this has gone completely off topic, and I shall hence forth cease to contribute to this, and related threads. I think you may be correct. John

[sqlite] Re: SQLite and Columnar Databases

2007-12-17 Thread Yuvaraj Athur Raghuvir
Hello, Thanks for the interesting discussion. What I got so far is summarized below: 1) Row based versus Column based storage is an implementation detail. 2) SQL used for access is independent of storage mechanism adopted. 3) Row based storage with indices on all columns reaches read performance

Re: [sqlite] create table with datatype = DATE. SHould use as DATETIME or INTEGER.

2007-12-17 Thread John Stanton
Joanne, there are no bad questions, only bad answers. Use sqlite3_bind_double and your timestamp will be of type double (a 64 bit FP number), Joanne Pham wrote: Hi John, Thanks for the detail info. I am still very new to SQLite3 and sorry for the question. My application is used C++ to

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDeviceSQL?

2007-12-17 Thread Fred Williams
There you go! Thinking like an engineer (logical) and not management :-) I have met a few $100K+ programmers out there, but none were VB'ers. Just a bunch of "namby pamby" C and C++ wizards :-) Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday,

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread Fred Williams
It's the ones who never figure out how little they know that do all the damage... Fred > -Original Message- > From: John Elrick [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:22 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite.

RE: [sqlite] Improving performance of SQLite. Anyone heard ofDevice SQL?

2007-12-17 Thread Fred Williams
Went south in a rush. Agreed. BTW, I can drive a forklift, and a back hoe... Fred > -Original Message- > From: James Steward [mailto:[EMAIL PROTECTED] > Sent: Monday, December 17, 2007 6:43 PM > To: sqlite-users@sqlite.org > Subject: Re: [sqlite] Improving performance of SQLite. Anyone

[sqlite] Re: SQLite and Columnar Databases

2007-12-17 Thread Darren Duncan
At 6:59 AM +0530 12/18/07, Yuvaraj Athur Raghuvir wrote: Thanks for the interesting discussion. What I got so far is summarized below: 1) Row based versus Column based storage is an implementation detail. 2) SQL used for access is independent of storage mechanism adopted. 3) Row based storage