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
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 need to be not
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
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 dspai...@msn.com wrote:
hello all i am creating a text mud gamibng engine and has been going great up
until
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
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
On Tue, Sep 6, 2011 at 5:33 PM, Eduard Filipas eduard.fili...@volja.netwrote:
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 beal
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
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 =
