Re: [sqlite] System.Data.SQLite execute query without using of indexes

Your C# code is timing the entire loop while appending to a StringBuilder. This is going to be slower than simply running the SQLite query. I suggest trying the following change to get a clearer picture of the time spent executing the actual query: cmd.Prepare(); var dtStart =

Re: [sqlite] SQLite Cache Usage

Hi Pavel, On 7/9/2011 10:16 PM, Pavel Ivanov wrote: 1. If we have a 1MB cache (1000 pages x 1KB/page), is it allocated immediately and used or is it allocated as queries come in? Cache is not allocated immediately. It's allocated when SQLite needs to read something from disk (or write a newly

Re: [sqlite] sqlite3.h file?

On Tue, Sep 6, 2011 at 5:33 PM, Eduard Filipas wrote: > i searched your website and i cant find sqlite3.h file. where can i get > proper one? > http://www.sqlite.org/download.html it's part of the download bundles. Try the top link on that page. -- - stephan

[sqlite] SQLite giving error with nested inner joins

Hi, We make use of a number of queries which we also run against other databases. Consider this simplified example: SELECT psim_objects.ObjectName, property.AttributeTextValue, data.Attribute, data.AttributeUOM FROM psim_objects INNER JOIN (psim_objectdata data INNER JOIN psim_objectdata

[sqlite] sqlite3.h file?

Hi i searched your website and i cant find sqlite3.h file. where can i get proper one? regards Eduard Filipas ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] System.Data.SQLite execute query without using of indexes

Hi, I have a table with 10 000 000 records there is compound primary key (ObjectID, AttributeID) 1. when I exequte next query SELECT * FROM ObjectValue WHERE ObjectID=4 AND AttributeID=3; in managment tool e.g.sqliteadmin the time of execution is ~16ms (return result : 1 row) 2. execute

Re: [sqlite] Double Spaced Blob Text

I guess the database is encoded in UTF-16 and you are reading the text using sqlite3_column_blob instead of sqlite3_column_text. F. On Wed, Sep 7, 2011 at 5:15 PM, Daniel Spain wrote: > > > > > hello all i am creating a text mud gamibng engine and has been going great up >

Re: [sqlite] Double Spaced Blob Text

I sincerely doubt that sqlite is your problem as everybody else would be seeing the same problem. What is the prfmlt() function? I would suspect whatever is interpreting your output stream is the culprit. I've seen historically where a period can mean end-of-line. Michael D. Black

[sqlite] Double Spaced Blob Text

hello all i am creating a text mud gamibng engine and has been going great up until recently.when a user is examining their current room all the text is double spaced.i have tried this as both a blob and text field with a max length of 4096. here is my funtion to display long room

Re: [sqlite] SQLite Cache Usage

> 1. If we have a 1MB cache (1000 pages x 1KB/page), is it allocated > immediately and used or is it allocated as queries come in? Cache is not allocated immediately. It's allocated when SQLite needs to read something from disk (or write a newly created page). SQLite reads it and caches. > 2.

Re: [sqlite] Sqlite+ICU library and usage of LIKE

sreekumar...@gmail.com wrote: > The _ operator( match any single char in the string) does not seem to work.. > % is ok.. Show your data and your statement. Explain what outcome you observe, and how it differs from your expectations. -- Igor Tandetnik

Re: [sqlite] Sqlite+ICU library and usage of LIKE

The _ operator( match any single char in the string) does not seem to work.. % is ok.. Any clue? Sent from BlackBerry® on Airtel -Original Message- From: "Michael Stephenson" Sender: sqlite-users-boun...@sqlite.org Date: Tue, 6 Sep 2011 12:55:02 To: 'General

[sqlite] SQLite Cache Usage

Hi All, We are right now reviewing our usage of SQLite3 and are seeing how we can optimize its usage of disk space, run-time memory and its performance for our applications. So far, we are discovering a lot of new things - and it's very interesting to see things we may have overlooked at

Re: [sqlite] Order not case sensitive

Perfect, more more thanks. *Sintoni Stefano* On 09/07/2011 11:37 AM, Simon Slavin wrote: > On 7 Sep 2011, at 9:39am, Sintoni Stefano (GMAIL) wrote: > >> I need to perform one statement like the follow >> >> SELECT itemnames FROM table WHERE condition ORDER BY item ASC; >> >> But the ORDER BY

Re: [sqlite] Order not case sensitive

On 7 Sep 2011, at 9:39am, Sintoni Stefano (GMAIL) wrote: > I need to perform one statement like the follow > > SELECT itemnames FROM table WHERE condition ORDER BY item ASC; > > But the ORDER BY need to be not case-sensitive. sqlite> create table test (value text); sqlite> insert into test

[sqlite] Order not case sensitive

Hi, I need to perform one statement like the follow SELECT itemnames FROM table WHERE condition ORDER BY item ASC; But the ORDER BY need to be not case-sensitive. It's possible ? Thanks in advance. Stefano ___ sqlite-users mailing list

[sqlite] SIGBUS errors with WAL mode and multiple simultaneous updating clients

Hi, I seeing some SIGBUS faults during startup in the debug version of my app, but only when running under valgrind, and only for some clients. The faults appear to be occurring around the same location in the sqlite WAL code. If I disable WAL then there are no faults. If I don't run it under