RE: [sqlite] Java Hibernate support?

I think the question is: "Does Hibernate for Java support SQLite?" Ionut -Original Message- From: Richard Boehme [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 23, 2005 6:23 PM To: sqlite-users@sqlite.org Subject: [sqlite] Java Hibernate support? Does SQLite support Hibernate for

RE: [sqlite] sqlite performance variationin linux and windows

? I seems there is a lot o room for faster sqlite.dll by using other compiers than VC++ 6. We can run some tests to see which is faster ... Ionut Filip -Original Message- From: Robert Simpson [mailto:[EMAIL PROTECTED] Sent: Saturday, February 26, 2005 1:06 AM To: sqlite-users@sqlite.org; 'Ke

RE: [sqlite] sqlite performance variationin linux and windows

. I only did this for sqlite 2.8.*, but it should also work for 3.* . Is there any technical reason why the "stock" dll is build with VC++ 6 while better compilers are available ? Ionut Filip -Original Message- From: Neelamegam Appadurai [mailto:[EMAIL PROTECTED] Sent: Friday

RE: [sqlite] perfromance of UPDATE

Hi Nenad, Use prepared (precompiled) statements into a single transaction. It will be few hundred times faster ... Ionut -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 17, 2005 9:09 PM To: sqlite-users@sqlite.org Subject: [sqlite] perfromance

RE: [sqlite] Very slow insert???

Hello, > We have to insert ~ 8000 rows. It takes several minutes in P4 machine!!! Use precompiled statement(s) (see the docs) in a single transaction. Ionut Filip. ps: ... then tell us the difference ;) -Original Message- From: Buu Hao Tran [mailto:[EMAIL PROTECTED] Sent: Satur

[sqlite] sqlite_compile - bad return code

issues here: 1. Why sqlite_compile() returns SQLITE_OK if the call failed. I found this a little unintuitive, so it's probably a (rare) bug. 2. Why out of memory on my desktop 512 RAM / Win2K / VC7 dll. However this may have to do with platform specific reasons ... Regards, Ionut Filip

RE: [sqlite] sqliteOsEnterMutex() and sqliteOsLeaveMutex()

> Unsolicited advice: Your best bet is to run no more than one thread > in each process. If you need multiple threads, create multiple > processes to contain them. Writing applications with multiple > threads in the same address space is like smoking cigarettes: it > gives you a buzz, but in

RE: [sqlite] SQLite performance with mid-size databases

this on the list. > The speed results on the website [...] Here I think you need to make sure the concurrency access to the DB is not a bottleneck. Ionut Filip PS: You can also try to post a sample (partial) schema of your database. -Original Message- From: Richard Kuo [mailto:[EM

RE: [sqlite] Bulk insert or saving in memory database to file?

Hi, If should also consider using precompiled (prepared) INSERT statements. My tests on Windows (2000 Pro) shows that the pre-compiled insert statements are faster than COPY. But this may not be the case in your situation. Make your own test if it's about 300 M as you told. Ionut Filip

[sqlite] How to compile on Borland C++ Compiler 5.5 ?

Hello, I am interested to compile the sqlite.dll using Borland C++ Compiler. Can anyone tell me how to do this ? The http://www.sqlite.org/cvstrac/wiki?p=HowToCompile document covers only building with C++Builder, which is not free. Thanks, Ionut