Re: [sqlite] Vista problem on its aggressive "previous version"

2007-04-25 Thread Tian-Jian \"Barabbas\" [EMAIL PROTECTED]
Kees Nuyt 提到: On Wed, 25 Apr 2007 22:09:21 +0800, you wrote: Hi all, Is it possible to prevent this problem happens with SQLite DLL itself? Please refer to http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html for problem description. First of all: I have no

Re: [sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread Joe Wilson
Try compiling with sqlite3.c from http://sqlite.org/sqlite-source-3_3_17.zip It is already pre-generated and does not require generating the parser from the .y file. See: http://www.sqlite.org/cvstrac/wiki?p=TheAmalgamation --- [EMAIL PROTECTED] wrote: > arm developer suite v1.2 > support

Re: [sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread allen . zhang
arm developer suite v1.2 support arm7,arm9 Joe Wilson <[EMAIL PROTECTED]> 2007-04-26 11:03 Please respond to sqlite-users@sqlite.org To sqlite-users@sqlite.org cc Subject Re: [sqlite] how to compile sqlite3 in ads1.2 environment? What's an ads1.2? --- [EMAIL PROTECTED] wrote: >

Re: [sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread Joe Wilson
What's an ads1.2? --- [EMAIL PROTECTED] wrote: > Dose anybody compile the sqlite3 in the ads1.2 environment? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

[sqlite] lemon compile parse.y error for windows

2007-04-25 Thread allen . zhang
I compile the lemon.c in vc6 environment. (build it the win32 console application ) then I use the command lemon parse.y I successfully get the parse.h file but the file is not right. I only get 137 ids the follwing 15 ids do not exist in the parse.h TK_TO_TEXT TK_TO_BLOB TK_TO_NUMERIC

Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Kenneth LO
The only restriction is to escape \0. I've been storing GB2312, BIG5 and UTF8 Chinese characters since 2.x versions without any problem. Japanese/korean characters should be OK.

Re: [sqlite] more test suite problems on Windows

2007-04-25 Thread drh
Dennis Cote <[EMAIL PROTECTED]> wrote: > I'm still troubleshooting the test suite on Windows. > > I'm getting two failures on tests misc7-10 and misc7-11. These test look > like they should work on Windows without change. Can anybody suggest > what might be wrong? > Your previous changes left

[sqlite] yet another test suite problem on Windows

2007-04-25 Thread Dennis Cote
I am continuing to try to get the complete test suite to run on Windows. I have another strange error in test misc7-17.1: misc7-17.1... Error: couldn't open "test.db-journal": permission denied The TCL code for this test is:

RE: [sqlite] Odd performance issue under Windows

2007-04-25 Thread Noah Hart
>> Thanks Donald. The results are now identical. So, it has to do with >> buffer flushing differences between the machines. Now I have to >> figure out what the differences are given that the XP laptop is >> configured as shipped and is showing the performance improvement. > > >Addendum. I

Re: [sqlite] Odd performance issue under Windows - correction

2007-04-25 Thread John Elrick
John Elrick wrote: John Elrick wrote: Griggs, Donald wrote: John Elrick wrote: "what the heck is happening that is creating a better than order of magnitude difference in execution time on five out of seven Windows machines?". John, If the database is opened and closed just once

Re: [sqlite] Vista problem on its aggressive "previous version"

2007-04-25 Thread Kees Nuyt
On Wed, 25 Apr 2007 22:09:21 +0800, you wrote: >Hi all, > >Is it possible to prevent this problem happens with SQLite DLL itself? >Please refer to >http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html >for problem description. First of all: I have no hands on experience

Re: [sqlite] Odd performance issue under Windows

2007-04-25 Thread John Elrick
John Elrick wrote: Griggs, Donald wrote: John Elrick wrote: "what the heck is happening that is creating a better than order of magnitude difference in execution time on five out of seven Windows machines?". John, If the database is opened and closed just once for your testing, I

Re: [sqlite] Odd performance issue under Windows

2007-04-25 Thread John Elrick
Griggs, Donald wrote: John Elrick wrote: "what the heck is happening that is creating a better than order of magnitude difference in execution time on five out of seven Windows machines?". John, If the database is opened and closed just once for your testing, I think you can find

RE: [sqlite] Odd performance issue under Windows

2007-04-25 Thread Griggs, Donald
John Elrick wrote: > "what the heck is happening that is creating a better than order of > magnitude difference in execution time on five out of seven Windows > machines?". John, If the database is opened and closed just once for your testing, I think you can find out if buffer flushing is

Re: [sqlite] Odd performance issue under Windows

2007-04-25 Thread Gerry Snyder
John Elrick wrote: "what the heck is happening that is creating a better than order of magnitude difference in execution time on five out of seven Windows machines?". Sounds like different filesystem behavior, such as caching, returning before the writing is actually done, etc. Gerry

Re: [sqlite] Re: Odd performance issue under Windows

2007-04-25 Thread John Elrick
Igor Tandetnik wrote: John Elrick wrote: We tested the procedure under performance analysis on seven different Windows machines, ranging from Windows 2000, Windows XP and Vista. In five of the cases, inserting 128 rows outside of the context of a transaction takes 11 - 17 seconds. In the

[sqlite] Re: Odd performance issue under Windows

2007-04-25 Thread Igor Tandetnik
John Elrick wrote: We tested the procedure under performance analysis on seven different Windows machines, ranging from Windows 2000, Windows XP and Vista. In five of the cases, inserting 128 rows outside of the context of a transaction takes 11 - 17 seconds. In the other two cases, a Windows

Re: [sqlite] Borland C++Builder linking issue

2007-04-25 Thread Scott Hill
On 4/25/07, Dennis Cote <[EMAIL PROTECTED]> wrote: To use the sqlite3.dll with Borland C++ you need to build a Borland specific import library for the dll, and then add this library to your project. The library will open the sqlute3 dll whenever you call one of the included functions. This

[sqlite] Odd performance issue under Windows

2007-04-25 Thread John Elrick
I've encountered an unusual problem with SQLite performance under Windows and am hoping someone might have an idea of what might be happening. We are developing a Delphi application which uses SQLite compiled into the program. During one round of tests we discovered a section of code which

Re: [sqlite] another test suite failure under Windows

2007-04-25 Thread Dan Kennedy
> It seems like the use_up_files command must work sometimes, since > several iterations of the test worked (i.e. 6.1.1 and 6.1.2). I'm not > sure what to make of the sequence of test failures and successes before > it finally hangs. > > Since the comment indicates that this test is designed

Re: [sqlite] another test suite failure under Windows

2007-04-25 Thread Michael Schlenker
Dennis Cote schrieb: After fixing the exclusive2 test and running the quick test with no errors, I decided to try the complete test suite, alltest. I am getting failures on test misc7-6.1.x: misc7-6.1.1... Ok misc7-6.1.2... Ok misc7-6.1.3... Expected: [1] Got: [0]

[sqlite] another test suite failure under Windows

2007-04-25 Thread Dennis Cote
After fixing the exclusive2 test and running the quick test with no errors, I decided to try the complete test suite, alltest. I am getting failures on test misc7-6.1.x: misc7-6.1.1... Ok misc7-6.1.2... Ok misc7-6.1.3... Expected: [1] Got: [0] misc7-6.1.4... Ok

Re: [sqlite] Borland C++Builder linking issue

2007-04-25 Thread Dennis Cote
Scott Hill wrote: Hello, First time on this list. I am trying to get sqlite into an app using Borlands C++Builder. I have included the sqlite3.h file and the code compiles. However, when it tries to link I get an unresolved external for sqlite3_open, etc. Does anyone have any experience

[sqlite] Vista problem on its aggressive "previous version"

2007-04-25 Thread Tian-Jian \"Barabbas\" [EMAIL PROTECTED]
Hi all, Is it possible to prevent this problem happens with SQLite DLL itself? Please refer to http://b6s.blogspot.com/2007/04/previous-version-ghost-on-vista-can-be.html for problem description. Regards, /Mike/ - To

RE: [sqlite] Japanese-Korean characters

2007-04-25 Thread Allan, Mark
I think what he is trying to say is that you can store Japanese/Korean characters in your database using a UTF-8 or Unicode string. We currently use Sqlite and support Chinese, and plan to implement Japanese and Korean and have had no problems. We store the text as a UTF-8 encoded string.

Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Pavan
UTF-8 (or Unicode) rules! Thanks for the quick reply. But, I havent understood. Can you be bit more clear ? Best Regards, Pavan. On 4/25/07, Tian-Jian Barabbas [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: Pavan 提到: > Hi, > > Can we store/retrieve Japanese/korean characters in sqlite db ? >

Re: [sqlite] Japanese-Korean characters

2007-04-25 Thread Tian-Jian \"Barabbas\" [EMAIL PROTECTED]
Pavan 提到: Hi, Can we store/retrieve Japanese/korean characters in sqlite db ? Thanks, Pavan. UTF-8 (or Unicode) rules! Cheers, Mike - To unsubscribe, send email to [EMAIL PROTECTED]

[sqlite] Japanese-Korean characters

2007-04-25 Thread Pavan
Hi, Can we store/retrieve Japanese/korean characters in sqlite db ? Thanks, Pavan. -- ' Always finish stronger than you start *

[sqlite] Re: Some questions on hierarchical data (nested set model)

2007-04-25 Thread Jef Driesen
A. Pagaltzis wrote: * Jef Driesen <[EMAIL PROTECTED]> [2007-04-11 16:10]: I managed to solve this problem now. I had to write my solution (see below) in pseudo sql code (e.g some extra non-sql code was required) because sqlite does not support stored procedures. It think it is doable to

[sqlite] how to compile sqlite3 in ads1.2 environment?

2007-04-25 Thread allen . zhang
Dose anybody compile the sqlite3 in the ads1.2 environment?