Re: [sqlite] Errors on release mode during link

I'm guessing you have a mismatch on the code generation for the sqlite lib and the server component. Thats what normally causes that sort of error in VC. Mike M - Original Message - From: "Vanessa V. Nihues" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, March 17, 2004

Re: [sqlite] more performance questions

On Mar 17, 2004, at 5:44 PM, D. Richard Hipp wrote: Dave Hayden wrote: > I'm inserting a bunch of data loaded off the network into a table. Here at > the office, SQLite keeps up pretty well; at home on the cable modem, it's a > huge bottleneck. Is the database file on a network filesystem? If

Re: [sqlite] Getting max column on empty table

Instead of (select max(c) from t where n=20)+1 try select coalesce(max(c)+1, 1) from t where n = 20 Regards - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Getting max column on empty table

If I have a table that is empty and I want to compute an incrementing value in a non-unique column (I cannot use integer primary key since the column value won't be unique): (select max(c) from t where n=20)+1 where c is unique only within (n==20), then this works as long as the table has at

RE: [sqlite] performance question

> On my PC the following query requires about 53 seconds: > select * from TABG a, TABB b where (a.S='3' or a.S='12 or...) and > b.G=a.G order by a.G asc; > > (On Oracle with the same scheme and data it requires only 0.4 > seconds.) In my experience, even though SQLite has very low overhead

Re: [sqlite] SQLite & Big Database

In 03/17/2004 09:36 PM, Puneet Kishor wrote: Mateusz Łoskot wrote: [...] I am assuming that means it is a good thing. ;-) Certainly. -- Mateusz Łoskot, mateusz at loskot dot net GNU/Linux (Slackware 9.1) http://counter.li.org #220771

Re: [sqlite] SQLite for Win32 TCHAR

Hi, In 03/17/2004 07:35 AM, Nuno Lucas wrote: For the original poster: If you want a hint on how to do your wraping, > see the help on mbstowcs/wcstombs functions of the C runtime, > or MultiByteToWideChar/WideCharToMultiByte in the Win32 API. That's right. Nuno gives you a great hint. I'm using

[sqlite] SQLite & Big Database

Hi, I'm using SQLite for some time, mainly on Windows CE but on Linux and Windows 2000 too. My databases are not very big and they consist of about 10-30 tables. Now, I'm going to move one of my big database currently in MDB format that consists of about 110 tables and some of them stores a few

Re: [sqlite] aliasing columns in views

Andre Vehreschild wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you're sure this command resulted not in an error. As far as I understand the documentation the VIEW keyword is mandatory when creating a view. So this should be: CREATE VIEW qry_contacts AS My

Re: [sqlite] performance question

Hi, > I have a question about the performance of my SQLite DB, where the > db-file has about 20MB and which I use in a Java application via the > Java wrapper. First, your timing figures look indeed slower than what I would expect (using a somewhat similar DB in type and size and a similar

Re: [sqlite] aliasing columns in views

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you're sure this command resulted not in an error. As far as I understand the documentation the VIEW keyword is mandatory when creating a view. So this should be: > CREATE VIEW qry_contacts AS > SELECT c.contact_id, c.firstname,

Re: [sqlite] SQLite quite popular

I just recently found out about SQLite from a copy of the C/C++ Users Journal that a co-worker left on my desk. After reading just the first couple paragraphs of the article I said "Shazam! Just what I was looking for all this time!".. I'm sure lots of other people have discovered it recently

[sqlite] how to switch to asynchronous mode?

Hi, I just converted a DB from Oracle to SQLite and am now trying to improve the performance. On the performance comparison page of the sqlite.org website I read about an asynchronous mode, which performed faster in many cases. How can I switch SQLite to asynchronous mode? Thanks in advance,

RE: [sqlite] SQLite for Win32 TCHAR

This is to clarify what I meant: I would like to know if anyone has modified sqlite so that it entirely works with TCHAR, either when it is typedef'd as unsigned short or char (per UNICODE). This is an example of what I would like to see: sqlite *sqlite_open(LPTCSTR filename, int mode,

Re: [sqlite] SQLite quite popular

Greg Obleshchuk wrote: I don't [know] what Dr R stats are on downloads... Stats from this morning are shown below. These stats are for the website at http://www.sqlite.org/. The mirror site at http://www.hwaci.com/sw/sqlite/ gets about the same amount of traffic, but because that is a hosted