Christian Morlotte wrote:
>
> Would it be possible those Compact Framework binaries have some kind of
> error? Maybe they were developed for 64 bit systems? Is there another
> version I could use?
>
The files in the "sqlite-netFx35-binary-PocketPC-2008-1.0.84.0.zip" download
package are intende
Hi Richard,
On 14/3/2013 8:17 PM, Richard Hipp wrote:
On Thu, Mar 14, 2013 at 12:34 AM, Mohit Sindhwani wrote:
Hi, we are using SQLite3 + CEROD for a number of databases in an embedded
systems application running on Windows CE. We're finding unexpectedly long
time to open the database (0.5s
Eleytherios Stamatogiannakis wrote:
> right now our VTs do not implement xBestIndex at all
The documentation says:
| The xBestIndex method is required for every virtual table implementation.
If you had no xBestIndex implementation, SQLite would crash.
> so i guess SQLite uses a default value of
On Thu, Mar 14, 2013 at 4:28 PM, J Trahair
wrote:
> There will be times when the program running the SQLite database will copy
> the database file MySQLiteDatabase.db to another folder, where the copy will
> be zipped (compressed). What happens if another user (User B) is writing a
> record to
Dear all,
It's impossible to control the way SQLite locks the database. Read
uncommitted will result in a crash when I try to open the database with a
C# program. I use Mono version 3, Ubuntu version 12.04 LTS, Ubuntu 12.10,
Windows 7 and Windows XP. On all systems read uncommitted WILL FAIL I've
I'm testing a connection in a project targeting the Compact Framework and I
get exceptions that seem to point to a 32 bit vs 64 bit problem. I
downloaded these binaries:
sqlite-netFx35-binary-PocketPC-2008-1.0.84.0.zip
and I am using .NET 3.5 and a 32 bit Vista system. After failing for days I
us
Hi everyone
There will be times when the program running the SQLite database will copy the
database file MySQLiteDatabase.db to another folder, where the copy will be
zipped (compressed). What happens if another user (User B) is writing a record
to the db at the same moment that User A's progra
Thank You for the help everyone.
The problem was in my query. I have a trigger that updates the a
"last_modified" field anytime there is an update on a given record. My query
has a where clause that says ... last_modified < current_timestamp. So if
there were any updates that occur during the same
Thanks Hick for the information.
Also, right now our VTs do not implement xBestIndex at all, so i guess
SQLite uses a default value of 0.
We also have the case here, where a VT can have either 0 rows or
infinite rows (we also use SQLite for processing streams). So it seems
that we'll go with
SQLite uses a cost-based algorithm to formulate a query plan. Therefore you
must return a proper cost estimate in your virtual tables' xBestIndex function.
This is usually interpreted as similar to "how many (disk) accesses are
required" or "how many records will be returned". For your virtual t
10 matches
Mail list logo