Do you know that VS2012 has known optimizer bugs?
Pavel
On Apr 6, 2013 5:01 AM, ibrahim ibrahim.a...@googlemail.com wrote:
On 05.04.2013 17:01, Dan Kennedy wrote:
On 04/05/2013 09:08 PM, Rob Collie wrote:
Yeap, I'm on Visual Studio 2012. I've created a console app:
sqlite3 *oDatabase;
On Fri, Mar 29, 2013 at 12:17 PM, Jeff Archer
jsarc...@nanotronicsimaging.com wrote:
I have previously made an apparently bad assumption about this so now I
would like to go back to the beginning of the problem and ask the most
basic question first without any preconceived ideas.
This use
First of all in the statement above you don't gain benefit from
uniqueness and replace about 10k rows twice.
Are you sure? The SELECT in the INSERT OR UPDATE selects FROM
trans_counters_v AS c, the grouped temporary view. So it should only see any
given key pair once before it starts doing
On Tue, Mar 12, 2013 at 11:03 PM, David King dk...@ketralnis.com wrote:
At first I was just doing something like this pseducode:
update_counter(k1, k2, count=count+1, expires=now+count*1day)
if rows_updated != 1: insert_counter(k1, k2, count=1, expires=now+1day)
Assuming these 2 statements
On Wed, Mar 13, 2013 at 11:48 AM, David King dk...@ketralnis.com wrote:
BTW, in case you don't do that yet your best performance will be if
you prepare your UPDATE and INSERT statements only once and then do
bind + step + reset in that 100k times loop.
In principle I agree, but since the
On Tue, Mar 12, 2013 at 8:29 PM, David King dk...@ketralnis.com wrote:
I'm trying to find an efficient way to store simple incrementing integers but
I'm having trouble finding an efficient way to do it
My database looks like:
CREATE TABLE counters
k1, k2,
count, -- how many we've seen
On Sun, Mar 3, 2013 at 11:48 AM, Tom Matrix ratomat...@gmail.com wrote:
Hello,
I’ve encountered a problem, which is hardly reproducable on arbitrary
databases, therefore I attached one.
The problem is that inner join omits the result on large datasets. But
again, ’large’ does not necessarly
On Thu, Feb 28, 2013 at 10:50 PM, Gert Van Assche ger...@datamundi.be wrote:
All, I don't know if this is possible.
A segment in table Files contains a record Content with a fields like
this XXX
Needs to become XXX 123 456 78 90
Based on a Translation
Example, If I insert 10 records and loop a query I receive
10, 10, 10, 10, results
But, if I change one of the records during the loop I get
10, 10, update record, 9, 10,
This sounds gibberish. Could you please post your database schema and
exact queries you issue in the exact
On Tue, Feb 26, 2013 at 2:29 PM, Igor Tandetnik i...@tandetnik.org wrote:
On 2/26/2013 5:13 PM, anydacdev anydacdev wrote:
I am struggling with SQLite's support for Oracle's DUAL table.
The updated statement, now including Oracle's DUAL looks like.
MERGE INTO x TGT
USING (SELECT 'A_NAME'
That's SQL standard -- query with aggregate functions always return at
least one row.
Pavel
On Fri, Feb 22, 2013 at 12:06 PM, Pierre Chatelier k...@club-internet.fr
wrote:
Hello,
[tested under 3.6.12 and 3.7.15.2]
I have a question regarding the use of aggregate functions.
Let's imagine
On Tue, Feb 19, 2013 at 1:39 AM, mikkelzuuu mikkelz...@gmail.com wrote:
Hey guys, I'm getting this error (see title)
I'm using C# by the way.
string StrQuery = @INSERT INTO Test VALUES ( +
dataGridView1.Rows[i].Cells[Column1].Value + , +
dataGridView1.Rows[i].Cells[Column2].Value + , +
Don't know if the index is updated after each row delete or after the whole
delete transaction is commited. For the first you can try:
time sqlite3 trip.db PRAGMA automatic_index= FALSE; delete from trip where
key=1400;PRAGMA automatic_index= TRUE; reindex trip
PRAGMA automatic_index has
Anyone out there know how to correct this undesirable behaviour?
PS. This only happens over NFS - local DB files behave as expected and fill
the OS page cache.
Don't write your database to NFS. I'd guess that your problem is that
NFS driver for some reason thinks that the file was changed on
On Fri, Feb 1, 2013 at 6:42 AM, message adams message.ad...@gmail.com wrote:
Greetings;
I've recently started using sqlite within Python, to help unit-test my
applications.
My applications actually run against sybase, but I'd love to use a
connection to an in-memory sqlite to carry out my
to run with
synchronization = OFF and gain the additional performance benefits.
Let me know if I missed something and I hope this makes things clearer.
Shuki
On Sat, Jan 26, 2013 at 10:31 PM, Pavel Ivanov paiva...@gmail.com wrote:
On Sat, Jan 26, 2013 at 6:50 PM, Shuki Sasson gur.mons
Sasson gur.mons...@gmail.com wrote:
Pick up any book about UFS and read about the journal...
Shuki
On Sun, Jan 27, 2013 at 7:56 PM, Pavel Ivanov paiva...@gmail.com wrote:
So in any file system that supports journaling fwrite is blocked until
all
metadata and data changes are made
On Sat, Jan 26, 2013 at 6:50 PM, Shuki Sasson gur.mons...@gmail.com wrote:
Hi all, I read the documentation about the synchronization pragma.
It got to do with how often xSync method is called.
With synchronization = FULL xSync is called after each and every change to
the DataBase file as far
On Wed, Jan 9, 2013 at 6:06 AM, a...@zator.com wrote:
Mensaje original
De: Clemens Ladisch clem...@ladisch.de
Para: sqlite-users@sqlite.org
Fecha: Wed, 09 Jan 2013 14:25:31 +0100
Asunto: Re: [sqlite] Problem whit sqlite_prepare_v2() in 3.7.5 version
andlater
You may be hitting the memory fragmentation issue. Try to run your
application with different memory managers (Hoard is my favorite -
http://www.hoard.org/) and see if the memory consumption is the same.
Also if you close all connections to your database (and other SQLite
databases too) does
I believe you can get this functionality now by compiling SQLite code
using cygwin compiler, not a Win32 one (and not downloading dll
library from sqlite.org website).
Pavel
On Wed, Dec 26, 2012 at 9:19 PM, Daniel Colascione dan...@dancol.org wrote:
Creating temporary tables fails in Cygwin
On Wed, Dec 26, 2012 at 9:55 PM, Daniel Colascione dan...@dancol.org wrote:
On 12/26/12 9:54 PM, Pavel Ivanov wrote:
I believe you can get this functionality now by compiling SQLite code
using cygwin compiler, not a Win32 one (and not downloading dll
library from sqlite.org website
Do you execute all updates as one call to sqlite_exec? Or as separate
calls to sqlite_exec or sqlite_prepare/sqlite_step? If separate then
do you check return value from the calls? And do you execute
BEGIN/COMMIT somewhere?
Pavel
On Sun, Dec 23, 2012 at 2:37 PM, Alem Biscan biscana...@gmail.com
row affected value. Well it makes sense somehow.. It
cannot know how many view's visible rows were affected. It lowers the
coolnes of views and instead of trigs.
Thanx
On Mon, Dec 24, 2012 at 12:15 AM, Pavel Ivanov paiva...@gmail.com wrote:
Do you execute all updates as one call
I have found that when using SQLite under Windows if you execute an update
statement and then a select statement, the database is locked until the
select statement is finished. How can I stop this from happening?
Note that you don't have to execute UPDATE before the SELECT to
reproduce that.
# http://answers.oreilly.com/topic/1955-how-to-use-full-text-search-in-sqlite/
Unlike traditional tables, the ROWID of an FTS table is stable through
a vacuum (VACUUM in Appendix C), so it can be reliably referenced
through a foreign key.
I'm not sure who wrote that but this page
I'd say generally speaking your way of storing data has no significant
downsides. There's just one but: if each row in your table stores pretty
significant amount of data (blobs, long text fields or just lots of
different fields) you'd better not make your ItemID INTEGER PRIMARY KEY.
Because
This problem was fixed here http://www.sqlite.org/src/info/5526e0aa3c.
It will appear in the next version of SQLite.
Pavel
On Mon, Oct 29, 2012 at 5:41 AM, NSRT Mail account.
joecool2...@yahoo.com wrote:
In the example, I just realized something that makes matters worse.
sqlite SELECT id AS
and varied differences. I'm just *also*
interested in this very specific issue.
-david
On Sun, Oct 28, 2012 at 12:38 PM, Pavel Ivanov paiva...@gmail.com wrote:
That said, I'd still welcome any quick summary of the differences between
sqlite and mysql when it comes to fragmentation.
This is far
/gmane.comp.db.sqlite.general/71868
On Sun, Oct 28, 2012 at 2:12 PM, Pavel Ivanov paiva...@gmail.com wrote:
OK. Curiosity is a good thing in certain situations. But could you
kindly tell me what will you do with this information (assuming it's
possible to obtain it of course)?
Pavel
On Sat
That said, I'd still welcome any quick summary of the differences between
sqlite and mysql when it comes to fragmentation.
This is far from main differences between sqlite and mysql that you
should consider if you want to choose between them unless of course
your question is just about an
I guess this can stand as one more argument for not using SQLite over
NFS. Another argument could be found here:
http://www.sqlite.org/lockingv3.html#how_to_corrupt.
Pavel
On Wed, Oct 24, 2012 at 2:01 PM, Efim Dyadkin efim.dyad...@pdgm.com wrote:
I was probably not quite specific. So I would
SQLite expects all paths to be in UTF-8 (non-standard for Win but the
same for all platforms). Is your path in UTF-8 or in some other system
encoding?
Pavel
On Tue, Oct 23, 2012 at 6:28 AM, Václav Jirovský
vaclav.jirov...@gmail.com wrote:
Hello,
I tried to use SQLite 3.7.14.1 with sqlite-net
On Sat, Oct 20, 2012 at 10:41 PM, Igor Korot ikoro...@gmail.com wrote:
Hi, ALL,
According to http://www.sqlite.org/foreignkeys.html the FOREIGN KEY
support is disabled by default.
In order to enable it I need to compile SQLITE with 2 defines undefined.
Which also undefined by default. Any
Var Alice := Db.SelectRecord('SELECT * FROM client WHERE client_name = ?', [
'alice' ]);
1. If I drop record for alice from db and then access column data in
prepared stmt will it work OK?
If the select statement wasn't reset or finalized, you won't be able to
delete a record from the
On Thu, Oct 18, 2012 at 6:32 AM, Daniel Polski dan...@agelektronik.se wrote:
The SELECT statement, including the _prepare() stage and all the _step()s
until you've reached the last row, and then the _finalize(), is all one
process. They're all part of the statement and you can assume that the
The problem is you are starting read-only transaction by executing
SELECT and then try to convert this transaction into writing one by
executing BEGIN IMMEDIATE. If in such situation SQLITE_BUSY is
returned you have to finish the transaction and start it again. In
your code solution is easy:
What kind of interpreter does the query executor uses? How important is the
interpreter's speed, to SQLite's speed ?
SQLite doesn't have interpreter, it has parser. I guess this makes the
rest of your email inapplicable.
Pavel
On Sun, Oct 14, 2012 at 4:38 AM, Elefterios Stamatogiannakis
On Sun, Oct 14, 2012 at 12:07 PM, Ryan Johnson
ryan.john...@cs.utoronto.ca wrote:
On 14/10/2012 2:26 PM, Pavel Ivanov wrote:
What kind of interpreter does the query executor uses? How important is
the
interpreter's speed, to SQLite's speed ?
SQLite doesn't have interpreter, it has parser. I
Well, an article on write barriers published in May 2007 can't
contradict the statement that barriers don't exist these days. :)
Pavel
On Fri, Oct 12, 2012 at 5:38 AM, Black, Michael (IS)
michael.bla...@ngc.com wrote:
There isn't Somebody sure wasted their time on this article then...
On Thu, Oct 11, 2012 at 7:09 AM, Hamish Symington
ham...@lightbluesoftware.com wrote:
Note that I was mistaken earlier when I said that X=Y and Y=X should
result in the same answer. If X and Y have different default collating
sequences, then X=Y does not mean the same thing as Y=X and so the
See http://www.sqlite.org/src/wiki?name=Bug+Reports .
Pavel
On Mon, Oct 1, 2012 at 3:10 AM, Álvaro García gts.agar...@gmail.com wrote:
I Have a problem with Entity framework and SQLite and I would like to open a
ticket to expose my problem, but I don't see the way to open the ticket.
could
On Wed, Sep 26, 2012 at 5:55 AM, Simon Slavin slav...@bigfraud.org wrote:
On 26 Sep 2012, at 5:42am, Dan Kennedy danielk1...@gmail.com wrote:
So when SQLite requires a temporary
file, it normally creates and opens a file with a randomized name
in /tmp then calls unlink() on it immediately -
On Wed, Sep 19, 2012 at 7:10 PM, Mohd Radzi Ibrahim imra...@gmail.com wrote:
On Thu, Sep 20, 2012 at 12:58 AM, Igor Tandetnik itandet...@mvps.orgwrote:
On 9/19/2012 12:51 PM, joe.fis...@tanguaylab.com wrote:
Too bad SQLite doesn't yet support SQL Window Functions.
Are there any SQLite
On Thu, Sep 13, 2012 at 9:29 PM, Igor Tandetnik itandet...@mvps.org wrote:
Pavel Ivanov paiva...@gmail.com wrote:
On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 9/13/2012 4:39 PM, Petite Abeille wrote:
On Sep 13, 2012, at 10:24 PM, Igor Tandetnik itandet
On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik itandet...@mvps.org wrote:
Pavel Ivanov paiva...@gmail.com wrote:
There's another way how it could make sense - if you read that excerpt
in context. ;-) The statement-level read consistency definition
cited by Petite is the transaction isolation
On Fri, Sep 14, 2012 at 8:57 AM, Igor Tandetnik itandet...@mvps.org wrote:
On 9/14/2012 10:36 AM, Pavel Ivanov wrote:
On Fri, Sep 14, 2012 at 5:58 AM, Igor Tandetnik itandet...@mvps.org
wrote:
Wait a minute. If statement-level read consistency only applies to two
queries in different
On Thu, Sep 13, 2012 at 3:36 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 9/13/2012 4:39 PM, Petite Abeille wrote:
On Sep 13, 2012, at 10:24 PM, Igor Tandetnik itandet...@mvps.org wrote:
In other words, a select should only ever see what existed at the
beginning of the query, and that
However, bus errors are often the result of something in your own code, or of
not checking the result codes returned by all your previous SQLite3 calls.
Simon,
You are confusing bus errors with segmentation faults. They are
different things and bus errors inside SQLite can never be caused by
If pBuf points to an invalid memory it's possible that you use already
closed connection or already finalized statement. Or maybe your
application corrupts SQLite's memory. Try to run your program under a
memory debugger.
Pavel
On Sat, Sep 8, 2012 at 10:11 AM, David Levinson
Note: attachments are stripped out of this list. So if you want for
anybody else to see your zip file you need to put it on some website
and post link here.
About the problem you have: I wonder how are you sure that there
should be 50 rows in the database and not 49? If you are resetting the
OS
There's a documentation bug on the Release Notes page:
Enhancements to PRAGMA integrity_check and PRAGMA quick_check so that
they can optionally check just a single attached database install of
all attached databases.
Should be instead instead of install.
Pavel
On Tue, Sep 4, 2012 at 4:41
Maybe you have 32-bit SQLite.Interop.dll and don't have 64-bit
SQLite.Interop.dll?
Pavel
On Tue, Sep 4, 2012 at 2:49 PM, Joe Mistachkin sql...@mistachkin.com wrote:
After few tries, I've finally downloaded the 64 bits zip (
sqlite-netFx40-static-binary-bundle-x64-2010-1.0.81.0.zip) and
thanks a lot,
but about the second question,I write java code,and find if the connection
exceeds 17990,then will throws exception
This probably happened because your OS restricts number of open file
descriptors or something like that.
Pavel
On Sat, Sep 1, 2012 at 7:52 PM,
If all your inserts are in one transaction then pragma synchronous =
OFF won't affect your transaction speed too much. To understand
whether this pragma works or not you should measure how long it takes
to execute COMMIT (just this one statement). With synchronous = OFF
COMMIT will be executed
This is a documented change. See http://www.sqlite.org/releaselog/3_7_11.html:
Pending statements no longer block ROLLBACK. Instead, the pending
statement will return SQLITE_ABORT upon next access after the
ROLLBACK.
There was even some explanation of reasons for that somewhere on the list.
When I implement the same mechanism for saving the
memory database back to disk, the size of disk file is 4x of the original
disk file size.
What is original disk file size here? Is it an empty database,
database with some data, database with exactly the same data you are
restoring? If the
You can try to use authorizer
(http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to
me SQLite won't inform you about access to table2 in the first query.
Pavel
On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha
bishwa.shres...@gmail.com wrote:
Hi,
I am creating an sqlite3
Another idea for you:
In our test, on the other hand, each thread queries its own set of
rows from the table. So, based on your explanation, here each thread
should end up with its own set of pages (more or less). However, even
in this case, I still observe a near sequential performance.
There are four levels to the shared-cache locking model: transaction
level locking, table level locking, cache level locking, and schema
level locking. They are described in the following three sub-sections.
This would be a bad way of documenting this because cache level
locking works on a
As you don't have stmt defined anywhere this is apparently not the
actual program you run. Seeing the full source code would be more
helpful. If the whole source is too big try to reduce it to small
program reproducing the problem. It's possible that while attempting
to reduce program source
In each case the same thing happens, the messages briefly display, then
disappear
I think your sms-controlling app has synced the whole sms database
with some server. When you start your phone it shows you local data
but then it sees that server has latest data (maybe using modification
date on
I'm trying to convince myself that the subquery in latest_aliases only
executes once, and also that alias_info only runs latest_aliases once.
However, I'm not doing very well at convincing myself. Can someone confirm
this is true, or suggest a nice solution to get the current time function
Keith,
No SQL format can guarantee anything. And changing SQL format won't change
its execution plan - SQL optimizer will decide that for you. And I don't
know where did you take your information from but I can guarantee you that
with your query SQLite will execute strftime many times and OP's
On Sat, Jul 21, 2012 at 3:36 AM, AJ ONeal coola...@gmail.com wrote:
I naively tried
wget
https://raw.github.com/gist/3154964/d570955d45580c095c99de6eb0c378395d4b076d/sqlite3-fts4-rank.c
gcc -c sqlite3-fts4-rank.c -o sqlite3-fts4-rank.o
sqlite3
.load sqlite3-fts4-rank.o
But that didn't
On Sat, Jul 21, 2012 at 4:06 PM, AJ ONeal coola...@gmail.com wrote:
Now I see a number which matches my expectations:
SELECT hex(matchinfo(t1)) FROM t1 WHERE t1 MATCH 'default transaction
these semantics';
On Sat, Jul 21, 2012 at 7:35 PM, AJ ONeal coola...@gmail.com wrote:
Read the documentation carefully:
http://www.sqlite.org/fts3.html#matchinfo. Right the first paragraph:
The matchinfo function returns a blob value. If it is used within a
query that does not use the full-text index (a query
For quite some time now I've been getting reports of crashes in my iOS app.
Specifically these are caused by crashes in sqlite3_prepare_v2 and
sqlite_step. The associated code works fine most of the time. So I'm looking
for thoughts on how to find and fix the problem since there seems to be
There's no easy method of detecting memory corruption from inside your
own application, especially the memory that your application don't
control. You can use memory debuggers for that purpose. If you were on
Linux I would recommend to use valgrind. But I don't know if there are
any similar tools
On Thu, Jul 19, 2012 at 2:07 PM, Rick Maddy rma...@gmail.com wrote:
Didn't mean to imply that failing to check the return value resulted in
memory corruption. I was wondering if it was possible that one of the many
calls to sqlite3_bind_* in my code may actually be causing some memory
// here maybe NULL is returned ?
mydetails = (char*)sqlite3_column_text(stmt, 0 );
Check sqlite3_column_type() before calling sqlite3_column_text(). If
it returns SQLITE_NULL then you have NULL.
Pavel
On Wed, Jul 11, 2012 at 1:40 PM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
On Wed, Jul 11, 2012 at 2:00 PM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
If mydetails contains a value, and I delete this value with SQLite Database
Browser
it seems not to be a real NULL, has someone an explanation for this
behaviour ?
It depends on your meaning of word delete. But
, Jul 5, 2012 at 11:24 PM, Pavel Ivanov paiva...@gmail.com wrote:
The insert statement below should insert one row into table
PP_VIEWER_SETTINGS. Does it do that? Is it what you called does not
work? To insert several rows you need to write a huge join of
dblookup to itself, so your insert
On Thu, Jul 5, 2012 at 7:46 AM, T Ü shocking_blue2...@yahoo.com wrote:
I have an asp.net application.
I open a sqlite in-memory connection with SQLiteConnection conn = new
SQLiteConnection ( Data Source=:memory: ); command.
I read that by using cache=shared parameter, I can make that
On Thu, Jul 5, 2012 at 8:37 AM, T Ü shocking_blue2...@yahoo.com wrote:
By trying I found out that SQLiteConnection(Data
Source=:memory:;cache=shared); worked.
In a single aspx.page at cs code, first I open an in-memory database
connection
SQLiteConnection conn = new SQLiteConnection (
wrote:
It returns 3.6.23.1
From: Pavel Ivanov paiva...@gmail.com
To: T Ü shocking_blue2...@yahoo.com
Cc: General Discussion of SQLite Database sqlite-users@sqlite.org
Sent: Thursday, July 5, 2012 3:40 PM
Subject: Re: [sqlite] Multiple connections
The insert statement below should insert one row into table
PP_VIEWER_SETTINGS. Does it do that? Is it what you called does not
work? To insert several rows you need to write a huge join of
dblookup to itself, so your insert statement should look like this:
insert into PP_VIEWER_SETTINGS (...)
On Thu, Jul 5, 2012 at 10:54 AM, Jonathan Haws
jonathan.h...@sdl.usu.edu wrote:
I am fairly new to database development and I am working on an embedded
system where we are utilizing SQLite to manage some files and other
information that is being shared between processes. What I am doing is I
sqlite SELECT test_base.id, SUM(test_join.value) FROM test_base LEFT
JOIN test_join ON test_join.base_id = test_base.id GROUP BY
test_base.id HAVING SUM(test_join.value)='0';
sqlite
The last statement generates no results. There is no mention of a
special case for HAVING so I would assume
On Tue, Jul 3, 2012 at 9:21 AM, Paul van Helden p...@planetgis.co.za wrote:
So rather than holding your breath for Oracle to change I'd recommend you
do it the portable way.
I'm not waiting for anything. My last question was simple: which is
better? Since MySQL does it the correct way perhaps
On Tue, Jul 3, 2012 at 10:55 AM, Jay A. Kreibich j...@kreibi.ch wrote:
On Tue, Jul 03, 2012 at 02:43:29PM +0200, Paul van Helden scratched on the
wall:
The statement UPDATE table SET column=NULL updates every row in the
table. The fact that some rows may already have a NULL in that
On Mon, Jul 2, 2012 at 4:02 PM, deltagam...@gmx.net deltagam...@gmx.net wrote:
Hello,
I couldnt find in the documentation what the max size of TEXT field/column
is.
http://www.sqlite.org/limits.html#max_length
By default it's 10^9 bytes and cannot be more than 2^31 - 1.
Pavel
On Fri, Jun 29, 2012 at 4:55 PM, Jeff Archer jarch...@yahoo.com wrote:
Kevin Benson kevin.m.benson at gmail.com Fri Jun 29 16:32:55 EDT 2012
The mention of SQLITE_SCHEMA error and sqlite3VdbeExec() sounds like maybe
you're fighting an expired statement???
Not likely. I do Prepare, Bind, Step,
On Thu, Jun 28, 2012 at 9:54 AM, Hector Guilarte hector...@gmail.com wrote:
I don't think it would.
Connection conn = DriverManager.getConnection(jdbc:sqlite:sample.db,
config.toProperties());
is telling to open a connection to the file sample.db which is located in
the same folder as the
I think SQLITE_SCHEMA can happen even if you run things like CREATE
TABLE or ALTER TABLE on the same connection. Also ATTACH DATABASE and
DETACH DATABASE should invalidate all statements prepared before that.
Pavel
On Thu, Jun 28, 2012 at 9:58 AM, Marc L. Allen
mlal...@outsitenetworks.com
You are leaking stmt statement (re-preparing without finaliznig) and
your call to sqlite3_close returns SQLITE_ERROR because of that, but
you don't even check that so you are leaking database connections as
well.
Pavel
On Tue, Jun 26, 2012 at 11:01 AM, deltagam...@gmx.net
deltagam...@gmx.net
On Tue, Jun 26, 2012 at 11:50 AM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
Am 26.06.2012 17:08, schrieb Pavel Ivanov:
You are leaking stmt statement (re-preparing without finaliznig) and
your call to sqlite3_close returns SQLITE_ERROR because of that, but
you don't even check that so
sqlite3_open().
Pavel
On Tue, Jun 26, 2012 at 12:27 PM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
Am 26.06.2012 18:00, schrieb Pavel Ivanov:
On Tue, Jun 26, 2012 at 11:50 AM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
Am 26.06.2012 17:08, schrieb Pavel Ivanov:
You are leaking stmt
...@sqlite.org wrote:
Message: 5
Date: Fri, 22 Jun 2012 19:17:39 -0400
From: Pavel Ivanov paiva...@gmail.com
To: General Discussion of SQLite Database sqlite-users@sqlite.org
Subject: Re: [sqlite] Selecting from a GROUP Select
Message-ID:
cag1a4rtd4itkhmp6srmn81lof35ckndb464rh1wjuax-8si
On Tue, Jun 26, 2012 at 3:02 PM, Igor Tandetnik itandet...@mvps.org wrote:
On 6/26/2012 1:19 PM, Peter Haworth wrote:
I still have the issue that, in order to be selected, the rows in the
groups containing two entries must have a different value in a specific
column.
I'm not quite sure I
On Tue, Jun 26, 2012 at 8:48 PM, Stephen Chrzanowski
pontia...@gmail.com wrote:
All;
When you compile the amalgamation with your source code, doesn't the
compiler reject/not include/remove/doesn't consider the code that could
have been generated from the actual final build? In other words,
On Mon, Jun 25, 2012 at 4:15 PM, deltagam...@gmx.net
deltagam...@gmx.net wrote:
Hello,
Im using MSVS 2010 for an c++ GUI project.
After including sqlite3.h and sqlite3.c from the amalgamation-3071200
and with the Project Properties-- C/C++ -- Precompiled Headers --
Precompiled Header -- Use
On Mon, Jun 25, 2012 at 10:05 PM, Bo Peng ben@gmail.com wrote:
Are these multiple tables in a single database (file), or multiple databases
(files)? Multiple connections or a single connection?
Right now there are multiple read-only processes to read the same
file. If I go with any
On Sat, Jun 23, 2012 at 2:28 PM, Simon Slavin slav...@bigfraud.org wrote:
On 23 Jun 2012, at 7:14pm, Peter M. Friedrich
peter.friedr...@physik.stud.uni-erlangen.de wrote:
do you think it's possible to create a different backend? I want to
develop a relational database system which uses
:
Thank you(Pavel) for the prompt response.
Sqlite does auto commit for every 25k insertions. Do I need to change the
number from 25k to x ( for ex: 100)?
On Thu, Jun 21, 2012 at 7:54 AM, Pavel Ivanov paiva...@gmail.com wrote:
On Wed, Jun 20, 2012 at 11:33 PM, Durga D durga.d...@gmail.com
On Sat, Jun 23, 2012 at 9:21 PM, Dennis Volodomanov i...@psunrise.com wrote:
On 22/06/2012 9:48 AM, Dennis Volodomanov wrote:
I'll see if the new compilation options still make this happen, but it
takes a couple of hours for each test due to data volume and I'd need to run
a few tests (unless
On Sat, Jun 23, 2012 at 10:18 PM, Dennis Volodomanov i...@psunrise.com wrote:
It does raise an interesting question though - how is this handled in SQLite
internally? When there are two writers, both writing to the same DB (WAL
mode) and one of them crashes before reaching a checkpoint, will
On Sat, Jun 23, 2012 at 10:36 PM, Dennis Volodomanov i...@psunrise.com wrote:
On 24/06/2012 12:29 PM, Pavel Ivanov wrote:
AFAIK, checkpoints are application-specific, but SQLite prohibits
second writer until first one committed its transaction and released
database lock. So there can't
.
On the other hand, as far as you can see, should the code I have shown open
a database, create a table and then add data to the table?
Thanks!
- Original Message -
From: Pavel Ivanov
Sent: 06/21/12 01:08 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] C
Ask this on Android-related mailing list.
And if you include your populated database into application package
before installation and don't see any data after installation check
that you open your database with an absolute path otherwise you could
be opening some other database file, not the one
1 - 100 of 1164 matches
Mail list logo