Am 31.10.2013 14:09, schrieb Dominique Devienne:
[Userdefined functions in conjunction with fast Exists-checks
in Userland - vs. SQLites built-in indexing in case of In (List)]
I'm not convinced by this. The real table can be quite large, several
100's to 100,000's rows (up to 1+ million rows)
Am 29.10.2013 13:19, schrieb Dominique Devienne:
So, after those functions are in place - where's the problem with:
select * from table where InMySmallUnsortedArrayExists(some_column)
select * from table where InMyLargerSortedArrayExists(some_column)
select * from table where
Am 16.10.2013 10:40, schrieb Dominique Devienne:
If I somehow missed a better work-around to this lack of array-binding, I'm
also interested of course, but obviously I'd prefer real array binding.
Maybe I'm missing something - but if I'd have a lot of InApp-
MemAllocations in the form of
Am 27.10.2013 08:41, schrieb Joe Fuller:
I’m trying t access sqllite database via vbscript.
I don’t want to use odbc just ado.net.
I'm pretty sure vbScript doesn't support .NET class-instancing directly,
vbScript wants COM-(Dlls, to instantiate classes from).
This is the sort of thing I’ve
Am 06.07.2013 18:58, schrieb j.merrill-
There are reasons to want what is in other SQL implementations
implemented with row_number() OVER (ORDER BY ...) but
disconnected Recordsets or for data passed across thread-
or machine-boundaries are definitely NOT valid reasons.
Since they are
Am 06.07.2013 19:25, schrieb Keith Medcalf:
Date: Fri, 05 Jul 2013 02:04:04 +0200
From: Olaf Schmidt n...@vbrichclient.com
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a way to return the row number? (NOT
the rowid)
Message-ID: kr52ig$e71$1...@ger.gmane.org
Content-Type: text
Am 03.07.2013 14:50, schrieb Keith Medcalf:
Given all that, I will NEVER use the pure sql (if I can use any
other solution).
given that the ordinal in the result set is a fallacious
concept being created for the convenience of an application
program which cannot deal with sets properly ...
Am 04.07.2013 20:36, schrieb James K. Lowden:
Yes, and there's your O(N log N): N for the SCAN and log(N) for the
SEARCH. To process 1,000,000 rows takes 1,000,000 accesses. To produce
the rank requires roughly 20 searches per row (given an appropriate
index), or 20,000,000 total accesses.
Am 28.06.2013 14:54, schrieb Christopher W. Steenwyk:
I have a rather large database (11 GB) that has two tables (one with
approximately 500,000 rows and another with approximately 50,000,000 rows).
In this database I am performing a query that joins these two tables to
produce approximately
Am 03.04.2013 23:11, schrieb Tiago Rodrigues:
I'm writing a small simulation app and for it I would like to use SQLite3
as an application file format, ...
...
For that, the simplest idea would be to use the online backup family of
functions, calling sqlite3_backup_init() and
Am 25.12.2012 22:18, schrieb Çağlar Orhan:
But every client has MS *.hta files and connecting to sqlite
over ODBC driver with vbscript.
What you rely on in this case, has nothing to do with
the WebServer (IIS) ... meaning the WebServer is not
used as a decoupling layer (over http).
What you
Am 09.12.2012 12:40, schrieb Simon Slavin:
On 9 Dec 2012, at 11:13am, Gilles Ganault gilles.gana...@free.fr wrote:
OTOH, whoever writes that application could always provide two
version: Basic (datagrid) and Pro (spreadsheet).
If you think you can make money by providing a basic app, write
Am 08.12.2012 22:09, schrieb Gilles Ganault:
Ok, but where are the large number of tools that would do that?
Features:
- very fast, very basic spreadsheet (not based on Excel or
Libre/OpenOffice)
I think you will have to be more specific with regards
to spreadsheet-like functionality.
Do
Am 18.10.2012 15:41, schrieb Abhinav:
Does SQL lite have an option of processes connecting to it from remote hosts
with a port number?
There's nothing directly built-in in the sqlite-library.
In case you need that for Windows (also depends on your development-
environment a bit) my
Am 06.10.2012 19:38, schrieb Bart Smissaert:
Times I get (65000 records, subtracting 2 fields defined as text in
the same table)
gives me following times:
method with julianday 0.4 secs
method with unixepoch 0.6 secs
using ctime etc. via VB wrapper 1.2 secs
What? A VB-implemented
Am 07.10.2012 23:43, schrieb Bart Smissaert:
I take it these files are not ready yet to put in a commercial app?
Not yet, but in 2-3 weeks the COM-interfaces of the new added
Classes (as for eaxmple the new convenience-class cMemDB) should
be stabilized and contain their final
Am 02.10.2012 21:23, schrieb Bart Smissaert:
Nice one, thanks for that.
Just in case you use the COM-Wrapper - and this operation takes
place in a plain Recordset-Select (and isn't stored somewhere
in the DB itself, e.g. in a Trigger), then you can reduce the
amount of function-calls a bit,
Am 24.09.2012 11:26, schrieb Sebastian Krysmanski:
Ok, I tried that. It definitely improves performance when using a lot
threads (15+)...
So I take it, that your last posted result here was using a
shared cache (in case of the multiple connections):
Am 20.09.2012 17:40, schrieb Sebastian Krysmanski:
What's your threading mode?
http://www.sqlite.org/threadsafe.html
Serialized
This could explain, why you get these performance-results, you
reported before (comparing multiple connections vs. a shared one):
I tested with a database
Am 21.09.2012 18:03, schrieb Olaf Schmidt:
...so I can effort the independent...
...arrgh, 'afford' of course, sorry for the noise...
Olaf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
Am 21.09.2012 19:28, schrieb Keith Medcalf:
So one needs to take care that the engine operates in the properly
matching modes for the two approaches when used in threads:
- shared Cache (single dbHdl over all threads) = serialized
(SQLITE_THREADSAFE=1)
- separate Caches (a dedicated
Am 10.09.2012 17:17, schrieb Bart Smissaert:
Ah, OK. I have a feeling that needs to be done either in your
application code or with a user defined SQLite function.
Somebody may prove me wrong.
Hi Bart,
since I know you're using my COM-Wrapper, a larger set
of Functions (in VBA-Style, similar
Am 05.09.2012 15:58, schrieb Igor Tandetnik:
Well, you could do something like this:
SELECT id, a, b, ..., mtime FROM tab t1
where mtime = (select min(mtime) from tab t2 where t2.id=t1.id)
ORDER BY mtime DESC;
Ah, nice ... this solves the problem of the potential
non-uniqueness of mtime...
Am 05.09.2012 16:57, schrieb Richard Hipp:
On Wed, Sep 5, 2012 at 10:53 AM, Olaf Schmidt s...@online.de wrote:
Am 05.09.2012 15:58, schrieb Igor Tandetnik:
Well, you could do something like this:
SELECT id, a, b, ..., mtime FROM tab t1
where mtime = (select min(mtime) from tab t2 where
Sachin Gupta scgu...@ipolicynetworks.com
schrieb im Newsbeitrag
news:51b335651c9a0c4ea520d47f23a580b414f5baf...@sinnodmbx001.techmahindra.com...
Following are the setup details that we are presuming that our
application will be put through test:
1. One writer thread (To avoid multiple
Doug pa...@poweradmin.com schrieb im
Newsbeitrag news:043201cba22a$f023df40$d06b9d...@poweradmin.com...
This is where I think the problems will crop up.
Can you imagine making a
network round trip for each row fetch, and then for each
column fetch of each row (sqlite3_column_type,
Chris Wolf schrieb
I can't resist adding my little opinion to yet another
business logic in stored procs vs. app layer holy war...
... yeah, seems this thread is evolving nicely in this
regard ...g
I usually prefer keeping the business logic in the application
layer and leaving the DB
BareFeetWare schrieb
On 12/11/2010, at 6:30 AM, Olaf Schmidt wrote:
jeff archer schrieb
From: Olaf Schmidt
Wednesday, November 10, 2010 9:07:19 AM
[Stored procedures in SQLite]
IMO stored procedure-support only makes
sense in Server-Instances which run on their own...
I
Chris Wolf schrieb
[Nested Recordsets/Resultsets as an alternative to Joins,
to shape-off redundancy in hierarchical requests...
as a native DB-Feature usable over Sybase StoredProcs...
...and the ADO-ShapeProvider as an example for an
alternative to use these things in a
BareFeetWare schrieb
On 13/11/2010, at 10:33 AM, Olaf Schmidt wrote:
If you have code (in either environment) that is
looping or grabbing one result and sticking it in a
second query, then your approach is probably flawed.
As you say: probably ... because it depends ...
(maybe
jeff archer schrieb
From: Olaf Schmidt
Wednesday, November 10, 2010 9:07:19 AM
[Stored procedures in SQLite]
IMO stored procedure-support only makes sense in
Server-Instances which run on their own...
I disagree. The overall design and structure of
applications using SQLite and therefor
Petite Abeille schrieb
On Nov 11, 2010, at 8:30 PM, Olaf Schmidt wrote:
If such an encapsulation of business-rules is sitting in the
DB itself - written in a proprietary DB-dialect, then you
cannot call such a thing a business-layer anymore.
Nonsense :))
Of course... ;-)
Nah
Tran Van Hoc tv...@vn.isb.co.jp schrieb im
Newsbeitrag news:43a0ef604a674b3fb80d1447b41f8...@isbvietnam.com...
[Stored procedures in SQLite]
IMO stored procedure-support only makes
sense in Server-Instances which run
on their own (and communicate over
different IPC-mechanisms, mainly sockets,
Bob Keeland keela...@yahoo.com schrieb
I am new to using SQLite but think that it may be good
for a project that I'm working on. I do my programming
in Visual Basic and don't know any C\C++.
Is there any problem with connecting with SQLite from
Visual Basic?
No.
Though the links Simon gave
:
...Where SomeColumnContent Like '%someother[*]part%'
If the above should not work, then this would be considered
a real wrapper-bug. ;-)
HTH
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman
Bart Smissaert bart.smissa...@gmail.com
schrieb im Newsbeitrag
news:aanlktikivzcbz81hqs28dtptoy8h6hc6nbukesmth...@mail.gmail.com...
...Where SomeColumnContent Like '%someother[*]part%'
Thanks Olaf, that works fine.
As my customers won't get this I think I might let my
code take care of
For Each Idx In Tbl.Indexes
'...
Next Idx
Next Tbl
Next Db
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:uk03v5h4ovo8un5hq68ldbotuf1fujr...@4ax.com...
On Mon, 17 May 2010 18:59:36 +0200, Olaf Schmidt
s...@online.de wrote:
I'd say, what you're looking for (in case a softer migration
of Excel-VBA-Devs is planned) is more a library
of such a WebSite ...
clientside-controlled Servercursors are a thing of the
past IMO, since they introduce more problems than
they solve.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Marcus Grimm mgr...@medcom-online.de schrieb im
Newsbeitrag news:4b9a01e8.2060...@medcom-online.de...
Increasing the number of threads does affect the overall
read performance slightly, example:
1 Thread: 11.2 sec
16 Threads: 8.2 sec
Single Process: 11sec.
I still would expect a better
Luke Evans luk...@me.com schrieb im Newsbeitrag
news:3be16206-d0c6-4041-a3a6-ca3c069ee...@me.com...
It's Objective-C, but all the SQLite interfacing bits are pure C
directly driving the SQLite API compiled into the program
(3.6.22 amalgamation).
Just to make sure ... do you really create
Luke Evans luk...@me.com schrieb im Newsbeitrag
news:5d6df6e4-c817-4788-a2a2-87dc5e32f...@me.com...
Thanks very much for your notes Olaf.
I've done as you suggest... I already had SQLITE_THREADSAFE=2
defined, but didn't have the SQLITE_OMIT_SHARED_CACHE
asserted (assuming private cache to be
processes can be
parallelized over CPU cores.
Pavel
On Fri, Mar 5, 2010 at 2:09 PM, Olaf Schmidt
s...@online.de wrote:
Luke Evans luk...@me.com schrieb im Newsbeitrag
news:5d6df6e4-c817-4788-a2a2-87dc5e32f...@me.com...
Thanks very much for your notes Olaf.
I've done as you suggest... I already
Pavel Ivanov paiva...@gmail.com schrieb im
Newsbeitrag
news:f3d9d2131003051131k23c7b61cueda0bcc72e6aa...@mail.gmail.com...
Oops, pressed send unintentionally...
Long story short - I suspect the open-call, to be the blocker
in your SharedCache-Mode=Off-scenario.
If database file is pretty
within a transaction -
that works fast as well.
Also consider using the binding-support of the wrapper
(the Command-Objects), to achieve faster (and more
typesafe) operations in write direction.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users
the real writes - the syncing - only happens within
the timer-event - you will risk no DB-corruption this way -
and in case of an unexpected Close of the App (due to whatever
reason), you will lose only the new data which was gathered
within the last timer-interval.
Olaf Schmidt
on the frequency and size of
the incoming new data-records, but also on the underlying
storage-media, the DB is hosted on - be it flash-based media,
as USB-sticks for example - or real Hard-Disks).
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users
process ...
...the timer-based transaction-syncing then only an
easier applicable workaround in environments which
cannot - (or don't want to) make use of the more efficient
working async-writer-thread implementation of the SQLite-engine).
Olaf Schmidt
that feature
available in a reliable and stable working way (playing well
with VB5/6) over the COM-interface.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Igor Tandetnik itandet...@mvps.org schrieb im
Newsbeitrag news:hgom0b$u0...@ger.gmane.org...
Sylvain Pointeau
sylvain.point...@gmail.com wrote:
How does sqlite handle ICU, I don't understand?
is it used only for the sort order?
No, the collation is used both for sorting and for equality
-
Stringliteral for the second Parameter of the Format-Function.
Nonetheless better to use a command-object for that task, in
case your current COM-wrapper has built-in support for that.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users
programmatically
(maybe at some PreProcessor-level, at least in the wrappers,
if something like that is not planned to integrate into the
core-engine).
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin
Tim Romano tim.rom...@yahoo.com schrieb im
Newsbeitrag news:4b0149c9.8000...@yahoo.com...
...
My query with the LIKE operator worked instantaneously
in MS-Access, BTW, where I originally had the database.
Since Access *.mdbs are often used with(in) VB- or
VBA-based applications - are you by
Tim Romano tim.rom...@yahoo.com schrieb im
Newsbeitrag news:4b017343.2040...@yahoo.com...
I've added a column to my table:
ALTER TABLE WORDS
ADD COLUMN spell varchar COLLATE NOCASE
and have then copied the contents of a 100% pure ASCII column
into column SPELL.
explain query plan
Rick Ratchford r...@amazingaccuracy.com
schrieb im Newsbeitrag news:dbfb2606d0c1448b930064474496a...@dolphin...
A while back, Igor gave me some help on pulling out mm/dd ranges (sets)
from
my table.
This is the code that does that.
sSQL = SELECT Date, Year, Month, Day, Open, High, Low,
David Morris dmor5...@bigpond.net.au schrieb im
Newsbeitrag news:26044356.p...@talk.nabble.com...
Have a peek at : http://www.sqlitening.com/support/index.php
Different language and could run under Wine on *nix
Ah - yes of course, I left it out here, since it currently is win only
(written in
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:10h3e55s5ml6kto9rkvasvv1ejc0ao2...@4ax.com...
Maybe someone will come up with a commercial alternative.
I for one would gladly pay for a single-EXE, no-brainer solution
that can run on Windows and *nix.
Hmm in this case, what
Pavel Ivanov paiva...@gmail.com schrieb im
Newsbeitrag
news:f3d9d2130910170753k6e680ecdtcb892f05b21cc...@mail.gmail.com...
select * from foo f1 where
(select count(*) from (select distinct b from foo f2 where f1.a = f2.a
and f2.b in (...) )) =
length_of_b_list
and b in (...);
Igor Tandetnik itandet...@mvps.org schrieb im
Newsbeitrag news:hbfjnu$v...@ger.gmane.org...
Olaf Schmidt wrote:
Just to add another one to the pile, any flaws I overlooked here...?
select *, count(b) c_b from foo
where b in (...)
group by a
having c_b = length_of_b_list
The OP
Ron Arts r...@arts-betel.org schrieb im
Newsbeitrag news:4adac5c1.5010...@arts-betel.org...
Then my program opens a socket, and starts accepting connections,
those connections are long lasting, and send messages that need
a fast reply. Many of the messages result in messages being send
to
by on average 25%,
I'd vote for the change... ;-)
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Ron Arts r...@arts-betel.org schrieb im
Newsbeitrag news:4ad19195.2060...@arts-betel.org...
I tried it, and indeed, this speeds up inserts tremendously as well,
but in fact I'm not at all concernced about insert speed, but much more
about
select speed. I use the following queries:
CREATE
-preparation efforts of your
table-list - but will be of benefit for your single-record-lookups,
based on your ... Where ID = ? .
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hugh Sasse h...@dmu.ac.uk schrieb im
Newsbeitrag
news:alpine.lfd.2.00.0908061712390.30...@trueman.cs.cse.dmu.ac.uk...
I wonder if the idea of suffix arrays would belp.
http://www.cs.dartmouth.edu/~doug/sarray/
I was about suggesting basically the same thing...
In case of Lukas' topics-table,
Rich Shepard rshep...@appl-ecosys.com schrieb im
Newsbeitrag news:alpine.lnx.2.00.0908031516300.3...@salmo.appl-ecosys.com...
It was set as String actually.
Rick,
That's the storage class; well, TEXT is the storage class.
Yep.
I believe this is a WRAPPER thing though.
Exactly.
The
on that,
or do you say: just be creative!.
Any input on that is appreciated - links to already existing
attempts or code-snippets too (not meaning the sorting-
approach itself, more regarding the integration into SQLite).
Regards,
Olaf Schmidt
___
sqlite
Paul Claessen p...@claessen.com schrieb im
Newsbeitrag news:005601ca0d3f$af8748e0$0e95da...@com...
Does anyone have any (simple) examples on how
to use sqlite from .ASP scripts for me?
Since you have CreateObject() available in these scripts,
any COM-based SQLite wrapper should do...
Olaf
Gilles Ganault gilles.gana...@free.fr schrieb im
Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com...
On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen
j...@dodgen.us wrote:
I would just use:
SELECT id AS Identification FROM foobar
Thanks. This is what I already use for displaying
the GPL/LGPL interfacing-issues only one
layer away).
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Rick Ratchford r...@amazingaccuracy.com
schrieb im Newsbeitrag news:c9ce387e92004e7b9c16ddaa2bd36...@dolphin...
So modifying TmpTable, which will still be needed for
other procedures, is not preferred. It would be great if
a recordset could be derived from it instead that contains
the
Rick Ratchford r...@amazingaccuracy.com
schrieb im Newsbeitrag news:152a3111f1ab4a9891b9158580cb7...@dolphin...
Maybe I misunderstood, but the impression I got was
that I should solve this problem using my VB language
rather than dealing with the DB.
I don't understand Simons reply that way
Christophe Leske i...@multimedial.de schrieb im
Newsbeitrag news:4a37b811.4030...@multimedial.de...
You write your own comparison function that would consider
these two strings equal. See sqlite3_create_function,
sqlite3_create_collation.
this problem pertains not only to Zürich, but to
lau stephen stephen@gmail.com schrieb
im Newsbeitrag
news:c26a05160906150443h44b8f434s46e6ab4215f61...@mail.gmail.com...
2009/6/14 Olaf Schmidt s...@online.de:
Each client could do (with a 1:10 relation of writes and reads)
Loop 1000 times
With LoopCounter Modulo 7 (case-switch)
case 0
stephen liu stephen@gmail.com schrieb
im Newsbeitrag
news:e5a33d590906140609h4f3f35fah9083be3560f5d...@mail.gmail.com...
http://code.google.com/p/sphivedb/
SPHiveDB is a server for sqlite database. It use JSON-RPC over
HTTP to expose a network interface to use SQLite database.
It supports
Olaf Schmidt s...@online.de schrieb im
Newsbeitrag news:h131eu$m0...@ger.gmane.org...
Loop 1000 times
With LoopCounter Modulo 7 (case-switch)
...
...
Ending up with 11 new records in the DB
g Ok - make the loop-counter 7000 to reach the
result of 11 new records.
Sorry
/english/newsticker/news/135446
And finally some new default-ext3-settings in the new kernel?
Solving the ext3 latency problem:
http://lwn.net/Articles/328363/
Is fsync() somehow messed up on linux currently?
Olaf Schmidt
P.S.
the following was my test-code:
Const DBPath As String = c
al...@ipac.caltech.edu schrieb im Newsbeitrag
news:634ea812687a6d75a1ddf17adce883fc.squir...@webmail.ipac.caltech.edu...
My primary concern now is to prevent a dead-lock.
That seems to make sense now (I assume you're working
near a deadlock with your multipe-client-requests, not
going
about the transferred byte-volume - maybe you could also
give the count of new records in case of insert-jobs)?
And do you work over GBit-Ethernet (or an even faster
NFS-channel)?
Regards,
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users
Rosemary Alles al...@ipac.caltech.edu schrieb im
Newsbeitrag news:57c55bd7-8d56-4913-adce-cbb2978dd...@ipac.caltech.edu...
What do you mean with cores?
Are these multiple client *machines* - or do we talk about
a sinlge client-machine with multiple (cpu-)cores here?
Multiple machines
(if working against non-shared SQLite-caches) -
so I hope, the sqlite-devs (although they often recommend,
to work singlethreaded wherever possible g) keep up their
good work on that front. :-)
Regards,
Olaf Schmidt
___
sqlite-users mailing list
sqlite
planned workaround?
In either case - that will be a nice addition to the engine -
thank you.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
-Recordset).
Please check it out from:
www.thecommon.net/2.html
www.thecommon.net/3.html (contains the Download-Links)
Regards,
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite
Jean-Christophe Deschamps j...@q-e-d.org
schrieb im Newsbeitrag news:7.0.1.0.2.20090312013713.0262b...@q-e-d.org...
Perhaps the best way is practice: what's the way to find
this guy named Éric or is it éric, or Eric, or eric?
He lives in MÜNCHEN, München, MUNCHEN,
Munchen or ... Munich.
IMO
with no problems.
Regards
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hi Devs,
This is not really a bug-report, but I want to
mention it nonetheless, since engine-crashes are
probably not what should be left unhandled, regardless
if the user tries to use the engine in an undefined-mode.
Let me explain:
Background:
Platform Windows.
StdCall-compile of the original
D. Richard Hipp d...@hwaci.com schrieb im
Newsbeitrag news:f6c1943c-f8ef-400a-800a-4afb2013f...@hwaci.com...
This forgotten switch was causing a JournalMode = Off.
Later on Transactions were used inside the Copy-over-
process from FireBird.
Hi,
LOCAL: RTREE 8x faster then my OLD implementation
NET: OLD is 2x faster then RTREE
Can I use some special caching concepts? How can I
improve the run-time in the NETWORK environment?
You could use/write also a small Appserver-Layer -
and perform the query locally then at the
Fabio Stranieri [EMAIL PROTECTED]
schrieb im Newsbeitrag
news:[EMAIL PROTECTED]
'11/10/2008 00:00:00'
As I see it, there's no need, to hardcode your
Dates this way.
You can use an appropriate Format-String to
retrieve that directly from VB-DateVariables:
Format(now,'dd\/mm\/ hh:mm:ss')
Toby Bascom [EMAIL PROTECTED]
schrieb im Newsbeitrag news:[EMAIL PROTECTED]
Olaf is, in a word, a genius!
Heh, don't make me blush here, especially in this group,
where the real DB-experts hang around...
Without the sqlite-engine my wrapper wouldn't exist.
I'd suggest the groups on the public
from other Databases.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
in regards to these concurrent scenarios - try to
find a good (threadpool-based) server-implementation
(or write your own) and try it yourself.
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo
-Performance and is
based on the original NWind.mdb, which is converted
(a conversion-class is included) to a NWind.db
automatically on first run (including the Indexes and
Views).
Regards,
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
, Demos for
fast SQLite-Recordset-transfers in a Client/Server-
scenario are included)
So, if COM-interfaces are no K.O.-criterion
for you, then give it a try... ;-)
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
Rs!ID, Rs!Txt '...and print its contents
Rs.MoveNext
Loop
Olaf Schmidt
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
with the wrapper from Olaf Schmidt.
Hi Bart,
the reason why you don't see any changes is,
that this is already the default in my version
of the SQLite-engine compile (sqlite35_engine.dll).
;-)
Olaf
___
sqlite-users mailing list
sqlite-users@sqlite.org
http
, to ask for an officially supported
interface-enhancement regarding this functionality, mainly
because of the new VFS and because I thought, you would
use its capabilities in either way for InMemory-DBs).
Regards,
Olaf Schmidt
--
View this message in context:
http://www.nabble.com/VFS-in-upcoming
(0.95, 1) - gives 0, wich is not correct of course
Regarding bankers rounding, wich rounds up in case of a
'5' at the appropriate position, the correct result should be 1.
(tested with 3.3.17)
Regards,
Olaf Schmidt
--
View this message in context:
http://www.nabble.com/error-in-round-function
select round(0.95, 1)
0.9
select round(9.95, 1)
9.9
select round(0.995, 2)
0.99
select round(9.995, 2)
9.99
(3.3.17 here)
As it should be, hmm.
On what OS have you tested?
If on windows, was it a GCC-compile or a MS-VC-compile?
Olaf
--
View this message in context:
Thanks to RBS and Alberto for testing...
So it seems the problem is somehow Windows-related
(maybe the VC-Compiler).
Think I'll override the Round-Function in my wrapper.
Regards,
Olaf
--
View this message in context:
http://www.nabble.com/error-in-round-function--tf3897765.html#a11052069
for the serverpart,
nor for the client-demo - all is working with registryless COM-
components out of the box, leaving no traces in your Win-registry.
In a second ZIP you will find VB6-Sources for both parts
(Client- and Server-Part).
http://www.thecommon.net/8.html
Olaf Schmidt
noname wrote:
I am
100 matches
Mail list logo