y one solution - using exclusive transaction. Am i right?
--
Alexander Batyrshin aka bash
Biomechanical Artificial Sabotage Humanoid
On Mon, Apr 6, 2009 at 3:04 PM, Dan wrote:
>
> On Apr 6, 2009, at 5:02 AM, Alexander Batyrshin wrote:
>
>> Hello all,
>> I have found that busy_
3_exec(db2, "INSERT INTO Blah VALUES ( 1, 'Test1' )" ,
NULL, NULL, &zErrMsg);
check_error(rc, zErrMsg);
sqlite3_close(db);
return 0;
}
---%<----
Most interesting thin
4096
Page-cache overflow: now 0 max3258200
Scratch memory used: now 0 max 0
Scratch overflow: now 0 max 33320 max-size 33320
Maximum memory usage: 112168 bytes
Current memory usage: 1080 bytes
Number of malloc() : -1 calls
make: ***
I mean what is benefits of using DBD::SQLite::Amalgamation? Where it
can be needed?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
On Sun, Sep 21, 2008 at 9:51 AM, P Kishor <[EMAIL PROTECTED]> wrote:
> On 9/21/08, Alexander Batyrshin <[EMAIL PROTE
Sorry for off-topic.
What is main difference between DBD::SQLite and DBD::SQLite::Amalgamation?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
On Sat, Sep 20, 2008 at 8:04 PM, P Kishor <[EMAIL PROTECTED]> wrote:
> I encountered this problem and solv
n_test in cc7AxOBb.o
_c_realloc_test in cc7AxOBb.o
_c_misuse_test in cc7AxOBb.o
_DbTraceHandler in ccUU2Qo6.o
_DbProfileHandler in ccUU2Qo6.o
_DbObjCmd in ccUU2Qo6.o
ld: symbol(s) not found
collect2: ld returned 1 exit status
make: *** [testfixture] Error 1
--
Alexander Baty
%.
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
On Sat, Sep 20, 2008 at 8:45 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> Hello everyone,
>
> I gets strange result from this query on SQLite-3.6.2
>
> SELECT
>town.id
9266
44544 9266
45229 9266
46376 9266
45927 9266
46645 9266
[]
Any ideas what's going on?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite-
> 2. I tried this first: [ select * from map where (x=1 and y=1) or (x=1 and
> y=2) or (x=1 and y=3) ] but that didn't use the index -- not on 3.5.6 anyway
AFAIK "OR" will always omit indexes, this is why I am trying to use "IN"
--
Alexander Batyrshin aka bash
I will use more than 3 keys, so I will create temporary memory
table with keys for this stuff.
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:808
Hello All,
For example we have table like this:
CREATE TABLE map (
name text,
x integer,
y integer
);
CREATE INDEX map_xy ON map(x,y);
How to query this table with "IN" keyword?
Query like this, doesn't work:
SELECT * FROM map WHERE (x,y) IN ((1,1),(1,2),(1,3));
--
Alex
ust A Little Bit Of
> Geekness]<http://feeds.feedburner.com/%7Er/JustALittleBitOfGeekness/%7E6/1>
> Le tre grandi virtù di un programmatore: pigrizia, impazienza e arroganza.
> (Larry Wall).
>
> On Fri, Apr 25, 2008 at 10:04 AM, Alexander Batyrshin <[EMAIL PROTECTED]>
ave SQL command like this "UPDATE ... SELECT" ?
In this case we have explicitly calls to SELECT which should get read
lock.
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite
On Mon, Mar 24, 2008 at 3:58 PM, <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > Hello,
> > Is it safe to use this algorithm:
> >
> > open_db
> > fork()
> > sql_do() // both parent and child exec
condition like LIMIT.
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
I got it. Fixed my program with "IMMEDIATE" transaction.
On Fri, Apr 25, 2008 at 12:01 AM, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]>
> wrote in message
> news:[EMAIL PROTECTED]
>
> >> D
> Dropping the read lock is the same as rolling back the
> transaction. The first process can, in fact, do this. And
> the second process is waiting for the first process to do
> this. But the first process cannot do it automatically. The
> application must issue a "COMMIT" or "ROLLBACK" c
the busy handlers,
> neither will make any progress. Therefore, SQLite returns SQLITE_BUSY
> for the first process, hoping that this will induce the first process
> to release its read lock and allow the second process to proceed"
>
> Rgds,
> Simon
>
> 2008
ext thread will have exclusive
> access to it.
>
> If you use pthreads you can use read and write locks to get concurrency
> on reads.
>
> To my mind syncing on a mutex is better and simpler than polling the
> resource using SQLITE_BUSY.
>
>
>
> Alexander Batyr
e polling or
> wait on a mutex or semaphore.
>
>
> Alexander Batyrshin wrote:
> > Hello All,
> >
> > I am observing situation, that my concurrency process does not have
> > access to SQLite database with equal probability.
> >
> &
asserts :/
So, I am wondering, is there any ideas how to avoid this?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
Hello All,
Is it possible that SQLite deadlocks if it uses attached databases?
I am not sure, but if check_all_db_and_lock_all_of_them() is not
atomic, it can be...
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
Hello,
Is it safe to use this algorithm:
open_db
fork()
sql_do() // both parent and child executes sql statements
close_db
I am not familiar with locking mechanism and I am afraid that if
parent and child will use the same DB handlers it can cause of DB
corruptions
--
Alexander Batyrshin
> Is it possible to refine/combine the above two sets of queries into one?
Yes. It's possible:
A)
SELECT e.to_node_id AS node_id FROM edge e WHERE
e.from_node_id = $node_id
UNION
SELECT e.from_node_id AS node_id FROM edge e WHERE
e.to_node_id = $node_id
B)
SELECT c
ode_id
> > )
> >
> > My questions -- is there a way to do both (a) and (b) better, and is
> > it possible to do them all in one query?
> >
> > --
> > Puneet Kishor http://punkish.eidesis.org/
> > Nelson Institute for Environmental Studies http://www.ne
o do them all in one query?
>
> --
> Puneet Kishor http://punkish.eidesis.org/
> Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/
> Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/
> _
Hello,
Is there any special arguments to ./configure for building sqlite3
(shell.c) shared linked to sqlite library?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello,
I found that there is some mess in quickstart manual -
http://www.sqlite.org/quickstart.html
At C code example some lines ends with " argv}; hd_resolve_one {0}; hd_puts {);"
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotag
ed??
>
> Cheers,
> Rob.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
--
Alexander Batyrshin aka bash
ba
The same here:
# wget http://sqlite.org/sqlite3-3.5.6-osx-x86.bin.gz
--12:29:52-- http://sqlite.org/sqlite3-3.5.6-osx-x86.bin.gz
=> `sqlite3-3.5.6-osx-x86.bin.gz'
Resolving sqlite.org... 67.18.92.124
Connecting to sqlite.org[67.18.92.124]:80... connected.
HTTP request sent, awaiting re
ew release (version 3.5.7) within a few
> days in order to fix the problem discovered by ticket #2927.
>
> --
> D. Richard Hipp <[EMAIL PROTECTED]>
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqli
atements and close database
without any errors.
Conclusion: avoid using $dbh->disconnect() for DBD::SQLite, instead
use "undef $dbh".
On Feb 5, 2008 3:37 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> Hello,
>
> > What do you expect to see? From the code, I'
?
> Are you building a web session manager using SQLite as the data store? How
> is Storable working for you? I usually just use Data::Dumper, and eval the
> stored hash. But doing the eval has always worried me :-))
It's work without any problems for me handling over 150k hits/
Hello all,
Is it possible to prepare statement and use it for several databases
with identical schemas?
And is it possible to create statement, re-open database and then use
it again for same database?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
Opss. Code with numbers looks like this:
$sth->execute;
my ($val) = $sth->fetchrow_array;
#[1] my ($val2) = $sth->fetchrow_array;
#[2] $sth->finish;
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mail
_BUSY) {
/* active statements! */
warn("closing dbh with active statement handles");
}
imp_dbh->db = NULL;
av_undef(imp_dbh->functions);
imp_dbh->functions = (AV *)NULL;
av_undef(imp_dbh->aggregates);
imp_dbh->aggregates = (AV *)
Oh... you know about it. Sorry
>Etc, etc, etc. I have tcl-devel installed, but I'm assuming I need
>some other tcl package? Any idea what I need?
On Jan 31, 2008 8:27 PM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
>> Looks like you built
pendResult'
> /tmp/sqlite-3.5.5/./src/test1.c:4017: undefined reference to
> `Tcl_GetInt'
> /tmp/sqlite-3.5.5/./src/test1.c:4019: undefined reference to
> `Tcl_AppendResult'
>
> Etc, etc, etc. I have tcl-devel installed, but I'm assuming I need
> some other tc
]
vtab6-9.1.1...
Expected: []
Got: [2 22 {}]
vtab6-9.2...
Expected: []
Got: [2 22 {}]
On Jan 31, 2008 7:27 PM, <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > How to get error messages from test? Scroll up and copy-paste?
L PROTECTED]>
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
--
Alexander Batyrshin aka bash
bytes
make: *** [test] Error 1
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
L PROTECTED]>
>
>
>
> -
> To unsubscribe, send email to [EMAIL PROTECTED]
> -
>
>
--
Alexander Batyrshin aka bash
I got better performance when started to use TEMP tables with
temp_store = MEMORY.
But everything depends on situation.
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe
7;t know to do that (and
> presumably there's no way it could know).
>
> HTH,
>
> Sam
>
>
> ---
> We're Hiring! Seeking a passionate developer to join our team building Flex
> based products. Position is in the Washington D.
For example i have this tabe:
CREATE TABLE t1 (
id int unique ON CONFLICT ROLLBACK,
val char
);
And I have to execute this sql file:
BEGIN TRANSACTION;
INSERT INTO t1 (id, val) VALUES(1, 'val1');
INSERT INTO t1 (id, val) VALUES(2, 'val2');
INSERT INTO t1 (id, val) VALUES(3, 'val3');
INSERT I
Yep. It is last line in this document. Somehow i missed it :)
On Jan 30, 2008 3:03 AM, P Kishor <[EMAIL PROTECTED]> wrote:
> On 1/29/08, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> > Hello all,
> > What is default ON CONFLICT clause?
>
> "The algorithm
Hello all,
What is default ON CONFLICT clause?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
Offtop: You are trying to make something like statistic for game?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
How i thought...
Thank you!
On Jan 29, 2008 5:44 AM, Cory Nelson <[EMAIL PROTECTED]> wrote:
> On Jan 28, 2008 2:45 PM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> > Hello All,
> > Is there any difference in speed of access for unique and usual index?
>
>
1, a, .., bar, 7
> 2, b, .., qux, 9
>
> Instead, I want only one occurrence of "name" What would be the syntax for
> this?
>
> Thanks,
>
> Puneet.
>
> -
> To unsubscribe, send emai
Hello All,
Is there any difference in speed of access for unique and usual index?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
making a shared object; recompile with -fPIC
> /usr/lib/gcc/x86_64-redhat-linux/4.0.0/../../../../lib64/libsqlite3.a:
> could not read symbols: Bad value
> collect2: ld returned 1 exit status
> make: *** [blib/arch/auto/DBD/SQLite/SQLite.so] Error 1
> #
>
> --- I suspect that it h
.0.8.6
>
> I think I should clean out all the sqlite libs and bins, is all i have
> to delete are sqlite3 and libsqlite3.so.0* on the system?
>
> thanks for the help
>
> Jim
>
>
>
>
>
> Alexander Batyrshin wrote:
> > There is two way of compiling DBD::SQLite:
Hello All,
I am interesting is there any benefits in SQLite built for 64 bit
linux platform (amd64)?
I am not good at subject of 32/64, but IMHO SQLite 64 should work
faster or I am wrong?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
the module.
>
> I do have 3.5.4 installed, it migh be that there could be a older
> version hiding someplace. not sure how to find it or delete it.
>
> I'm on fedora also a RHES
>
> Alexander Batyrshin wrote:
> > I have no problem with 3.5.4.
> > Maybe your
e
> is becoming zero. it was arround 16k after all my tables are created). i
> dont have any code in my application which deletes the db file or deletes
> all the tables in the db.
> does anyone know why this is happening?
>
> Thanks&Regards,
> Rasanth
>
--
Alexa
.2 with no success so far.
> >
> > anyone have any success yet? If so what is the magic.
> >
> > Jim
> >
> >
>
>
> -
>
> To unsubscribe, send email to [EMAIL PROTECTED]
Hello John,
Right now i am using apache + fcgid (fast-cgi).
I will try to keep database handler open. But i need to implement it,
because i am using now more than 200 databases.
On Jan 24, 2008 9:38 PM, John Stanton <[EMAIL PROTECTED]> wrote:
> Using Apache is the problem. The connections are no
$dbh, shared variables, and
> caching. For me, the investment isn't quite worth the benefit.
>
> -Clark
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
ge cache
> is most likely still valid) I saw a very big jump in performance.
>
> Perhaps that would help in your case too?
Sounds interesting, maybe it help me a little.
I am using Perl DBD::SQLite, so i need some investigation how this library work.
--
Alexander Batyrshin aka bash
bash
" which will be
between application and SQLite engine and which will do caching.
Do you know any extensions/modification/patch that allow to add cache feature?
--
Alexander Batyrshin aka bash
bash = Biomechanica Artifici
As usual your answer is perfect in explanation!
Thank you very much.
On Jan 24, 2008 2:49 AM, <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > Hello All,
> > I've found that SQLite-3.5.4 doesnt use index in this situatio
On Jan 21, 2008 12:58 AM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> On Jan 20, 2008 11:32 PM, <[EMAIL PROTECTED]> wrote:
> > "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > > Hello everyone.
> > > I've discover performan
0|0|TABLE t1
0|0|TABLE t2
In this case, SQLite should takes value from t2 via unique id INDEX,
but it doesn't
--
Alexander Batyrshin aka bash
bash = Biomechanica Artificial Sabotage Humanoid
-
To unsubscribe, s
On Jan 20, 2008 11:32 PM, <[EMAIL PROTECTED]> wrote:
> "Alexander Batyrshin" <[EMAIL PROTECTED]> wrote:
> > Hello everyone.
> > I've discover performance degradation due to update 3.3.17 -> 3.5.4.
> > This SQL query work very slowly:
On Jan 20, 2008 3:32 PM, Alexander Batyrshin <[EMAIL PROTECTED]> wrote:
> Hello everyone.
> I've discover performance degradation due to update 3.3.17 -> 3.5.4.
> This SQL query work very slowly:
>
> DELETE FROM
> population_stamp
> WHERE
&g
65|NotExists|0|72|
66|Rowid|0|0|
67|Column|0|2|
68|Column|0|1|
69|MakeIdxRec|2|0|dd
70|IdxDelete|1|0|
71|Delete|0|1|population_stamp
72|Goto|0|64|
73|Close|1|19|
74|Close|0|0|
75|Halt|0|0|
76|Transaction|0|1|
77|VerifyCookie|0|281|
78|Goto|0|1|
79|Noop|0|0|
--
Alexander Batyrshin aka bash
bash = Biomec
67 matches
Mail list logo
