Am 23.02.2020 um 20:23 schrieb Richard Damon:
An amount of 140 tables in such a "BibleVersions.db" is not
uncommon and can be managed by SQLite in a good performance.
I'm not sure that form of division would be good. One basic rule of
database normalization is that you don't break-up data bas
Am 21.02.2020 um 02:24 schrieb Chip Beaulieu:
I have a table with 4.5 million records with full text indexing.
> Reads are very fast, but deleting / inserting / updating
takes on average about 50 seconds per record.
I often do batches of 30,000 deletes / inserts at a time.
The last batch took
Have just seen (in https://www.sqlite.org/src/timeline),
that this compiletime-option was removed (2020-02-07).
Speaking as a wrapper-author...
Are there alternatives in sight, to further support:
- a "ReKey"-feature in a relatively compatible manner,
without breaking existing (user-)code, whi
Am 28.01.2020 um 12:18 schrieb Richard Hipp:
On 1/28/20, Howard Chu wrote:
Wait, really?
AFAICS embedded means in-process, no IPC required to operate.
Things like MySQL-embedded and H2 run a "server" as a thread instead
of as a separate process. Clients then use Inter-Thread Communication
Am 18.10.2019 um 19:45 schrieb Bart Smissaert:
Regarding:
With r(s2, s, i) As (Select 2, 1, 1 Union All
Select s2, (s2>0)*(s+s2/s)*.5, i+1 From r Where Abs(s2-s*s)>1e-12
Limit 32
) Select s From r Order By i Desc Limit 1
How would this work if I wanted to update all the values in a table c
Am 12.10.2019 um 16:47 schrieb Bart Smissaert:
Sorry, I forgot to tell that. It is date column with an integer number.
ID xValue xDate
1 130 40123
1 120 41232
1 140 40582
1 100 40888
1 110 42541
2 140 41225
2 130 41589
2 150
Am 15.10.2019 um 23:53 schrieb Simon Slavin:
... There is no reason for a table to disappear.
But sometimes intent... ;-)
Maybe one of the App-Users is an xkcd-fan...
https://xkcd.com/327/
@the OP
Don't tell us now, that the table in question
was indeed named "Students"...
Olaf
___
Am 19.10.2018 um 16:02 schrieb Winfried:
I have a bunch of hyperlinks in an SQLite database, and need to read
each page for validation before deleting the record.
To make it easier, the DB manager should launch the default web browser
when I double click on a column that contains a hyperlink.
Am 22.11.2017 um 01:29 schrieb Jens Alfke:
When I’ve run into this before, the requirement has been to support lists with
customizable ordering, like an outliner where the user can freely drag the rows
up and down.
Yep.
And therefore such cases should be handled at the App-Level IMO...
Ther
Am 28.10.2017 um 23:00 schrieb Richard Hipp:
On 10/27/17, Olaf Schmidt wrote:
The new CoRoutine-approach seems to slow down certain
ViewDefinitions (in comparison to running a Query directly).
Can you please download and try the latest "Prerelease Snapshot" from
https://
Am 28.10.2017 um 19:22 schrieb Bart Smissaert:
This is interesting, not so much for the performance regression, but for
the fact that the posted Northwind database has
spaces in table names and view names. I wasn't aware this is allowed
and it caused a lot of errors in my app. I have this nearly
Am 27.10.2017 um 21:11 schrieb Richard Hipp:
Thanks for the report.
Do you have any other interesting, complex, or slow queries
using your database that you can send me for testing purposes?
With regards to the NWind.db, the Invoices-View is the
one with the largest processing-time.
NWind.db
Am 27.10.2017 um 21:59 schrieb David Raymond:
Also getting 31ms for both...
Thanks for testing that guys...
I was able to get similar timings (about 30msec), when the
(quite large) resultset-output was delegated into a file...
To avoid doing expensive File-IO in that test, I'd recommend
to run
The new CoRoutine-approach seems to slow down certain
ViewDefinitions (in comparison to running a Query directly).
FWIW, here's a download-link to an NorthWind-SQLite-DB, which
already contains certain view-definitions:
http://vbRichClient.com/Downloads/NWind.zip
(an "Analyze"-command was already
Am 17.05.2017 um 19:08 schrieb David Raymond:
The unique index on DistinguishedName though is what gets used for that sub
query of the insert, so most definitely keep that one index for the whole load.
(The others can be left out until the end though)
I once had a similar scenario, and solv
Am 29.06.2016 um 07:52 schrieb Olaf Schmidt:
Sorry, the line below (of the Test-Script) does not match with the
little "folder-layout" I've mentioned in my previous post -
so it needs to be adapted to the concrete (absolute or relative)
path, where the manifest (along with the 3
Am 24.06.2016 um 10:48 schrieb Dominique Lagree:
I have a classic ASP application running on Windows / IIS to provide that would
use an sqlite database.
...
How can we access to sqlite through an interface (oledb ?) that could be called
from
classic ASP vbscript and could run just from a copy
Am 19.04.2016 um 20:34 schrieb Jarred Ford:
> Is it possible to create multiple in-memory databases and be able to access
> tables with a single query between them? For example, select * from
> db1.dbo.table1 db1 join db2.dbo.table1 db2 on db1.x = db2.x.
Yes, that's possible over appropriate Fi
Am 19.02.2016 um 14:31 schrieb Montes C?mara, Victor:
> I've been using sqlite in vba6 for some years
> using RichClient3 framework of Olaf Schmidt (www.datenhaus.de)
The new site (which offers a new version of the RichClient,
as well as new versions of __stdcall-compiled SQLit
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 ro
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 InMyHashListExists
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 t
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 dif
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 se
Am 06.07.2013 19:25, schrieb Keith Medcalf:
Date: Fri, 05 Jul 2013 02:04:04 +0200
From: Olaf Schmidt
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Is there a way to return the row number? (NOT
the rowid)
Message-ID:
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Am
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. Plus
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 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 4
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 sqlite3_backup_
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 d
Am 09.12.2012 12:40, schrieb Simon Slavin:
On 9 Dec 2012, at 11:13am, Gilles Ganault 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 one and market
it.
Pe
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 SQLite-CO
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 method-signatu
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 User-Defined-F
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, whe
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 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 dbHd
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/listi
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 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 16:57, schrieb Richard Hipp:
On Wed, Sep 5, 2012 at 10:53 AM, Olaf Schmidt 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 t2.id=t1.id
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...
"GS" schrieb im
Newsbeitrag news:ig582d$go...@dough.gmane.org...
> > That's memory-intensive - but "Ok" (and fast) for Testfiles
> > with that RowCount (filesize of your 10.5K-Rows
> > testfiles around 4-6MB I'd guess).
>
>
> I just checked a 21,000 line x 30 column delimited file
> and it is
"Alok Singh" schrieb
im Newsbeitrag
news:aanlktikhcyfsuybpjtv=+cd4asrddt-9+f7qx_qpq...@mail.gmail.com...
> yeah that's correct Simon, its in 0.6 sec to insert
> for 10.5K rows with 20 columns (2 files both
> having 10.5k rows)
That's the timing I would expect, if you'd have used
Garrys recommen
"Simon Slavin" schrieb im
Newsbeitrag news:8e8a9b9d-fd6c-4e4f-b43e-21f5fd846...@bigfraud.org...
> Alok is writing in a language which doesn't compile very well.
Nah, even with VB.NET it should be possible,
to bring the import "up to speed" ... at least a factor 20
improvement should be achievabl
"Alok Singh" schrieb
im Newsbeitrag
news:aanlktinopo0+3pzk77d=ov0kbgmd2j7p3ah3-jjfg...@mail.gmail.com...
[Importing from Text-Files]
> ... that's *PERFECT* , much faster than my expectation
> 0.6 min can able to access 10.5k row records.
If that's not a typo (and you mean 0.6 seconds instead) -
"Sachin Gupta"
schrieb im Newsbeitrag
news:51b335651c9a0c4ea520d47f23a580b414f5d4d...@sinnodmbx001.techmahindra.com...
> Thank you for the detailed response.
> It sure does help us a lot.
>
> One more Q for you:
> Considering the requirement that we have, if we relax
> the requirement of creatin
"Steve Ely" schrieb im
Newsbeitrag news:362389.42609...@web162002.mail.bf1.yahoo.com...
> My mistake. I had read that SQLite had an ActiveX,
> I guess they were refering to 3rd party vendors.
In the COM-Wrapper-section of:
http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers
you will find differe
"Sachin Gupta"
schrieb im Newsbeitrag
news:51b335651c9a0c4ea520d47f23a580b414f5cd5...@sinnodmbx001.techmahindra.com...
> --- The Application will be using the in memory SQLite
> as Cache.
You could also consider some sort of "sorted Dictionary"
(a Tree-Structure which allows fast "sorted indexed
"Sachin Gupta"
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 Writers. We don't
> actu
"Doug" 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,
> sqlite3_column_double,
"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.
> &
"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 DBEngine-ind
"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 S
"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 ...
> I usually prefer keeping the business logic in the application
> layer and leaving the
"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 thin
"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
"Tran Van Hoc" 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,
with their "Clie
"Bob Keeland" 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 you, are for
"Bart Smissaert"
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 this.
Perhaps a goo
which are equal to the "comparison-
descriptors" you have to "escape them" within brackets:
"...Where SomeColumnContent Like '%someother[*]part%'
If the above should not work, then this would be considered
a "real wrapper-bug". ;-)
HTH
Olaf Schmidt
"Gilles Ganault" schrieb im
Newsbeitrag news:uk03v5h4ovo8un5hq68ldbotuf1fujr...@4ax.com...
> On Mon, 17 May 2010 18:59:36 +0200, "Olaf Schmidt"
> wrote:
> >I'd say, what you're looking for (in case a "softer" migration
> >of Excel-
numerate
and readout an already existing schema (e.g. for visualizing in
a TreeView) per:
For Each Db In Cnn.Databases
For Each Tbl In DB.Tables
For Each Clm In Tbl.Columns
'...
Next Clm
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
work against
"RPC-Servers, or Application-Servers - or let's call them
*WebServers* ;-) ...over sockets (e.g. receiving JSON-
serialized Resultsets over http) - ... no matter what SQL-
engine is working in the backend of such a WebSite ...
"clientside-controlled Servercursors" a
"Marcus Grimm" 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 scaling, ...
IMO
"Pavel Ivanov" 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 large, q
l-space or user-space threads? Maybe this
library serializes execution of your threads when processes can be
parallelized over CPU cores.
Pavel
On Fri, Mar 5, 2010 at 2:09 PM, Olaf Schmidt
wrote:
>
> "Luke Evans" schrieb im Newsbeitrag
>
news:5d6df6e4-c817-4788-a2a2-8
"Luke Evans" 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 the de
"Luke Evans" 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 different DB-
ps which
also only work singlethreaded within a single 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
wo
ng first, which timer-interval
works best (depends somewhat 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
__
So, to be entirely sure, you could open all the Recordsets
ReadOnly (using the Optional Flag in the OpenRecordset-
method) - and then work only with Cnn.Executes or better
the Command-Objects in write-direction.
This way the "real writes" - the syncing - only happens within
(leaving it at its default FULL(2)) - instead you should
wrap larger insert- or update-actions 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".
O
ync thread.
So, just in case you're using the dhRichClient3-wrapper-lib,
there's currently no plan (and no time), to make 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" schrieb im
Newsbeitrag news:hgom0b$u0...@ger.gmane.org...
Sylvain Pointeau
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 check.
> However, ICU doesn't actually tre
quot;'yy\-mm\-dd'") & " AND " & _
Format(D2, "'yy\-mm\-dd'")
Or define a Const for the above shown Format-Def-
Stringliteral for the second Parameter of the Format-Function.
Nonetheless better to use a command-object for that t
ot;out of specification", if an
Update is performed inside an "Instead Of Insert" trigger,
but the above steps perform really good + it can be "formalized"
nicely, to construct the statements also programmatically
(maybe at some "PreProcessor-level", at least in the wrap
"Tim Romano" 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
> select * from
"Tim Romano" 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 any chance
using
"Rick Ratchford"
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, Close FROM ["
&
"David Morris" 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 PowerBasic). Alr
"Gilles Ganault" 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 about:
http://www.
"Ron Arts" 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 all other client
"Igor Tandetnik" 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
&
"Pavel Ivanov" 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 (...);
> Shouldn't this
p *total* mem-usage
of a running SQLite-engine-instance 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" 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 TABLE compan
- if possible, after
your "main-amount" of fillups was done - that adds some
additional time to your overall-data-preparation efforts of your
"table-list" - but will be of benefit for your single-record-lookups,
based on your "... Where ID = ? ".
Olaf Schmidt
"Hugh Sasse" 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, one would
pec exists, would it be possible to
design such a thing (at least "roughly", by an sqlite-expert) and
publish it here or on the sqlite-site, before I start working on that,
or do you say: "just be creative!".
Any input on that is apprec
"Rich Shepard" 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 COM-wrapper handl
"Paul Claessen" 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" schrieb im
Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com...
> On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen
> wrote:
> >I would just use:
> >
> >SELECT id AS Identification FROM foobar
>
> Thanks. This is what I already use for displaying the results, but
> then I
"Rick Ratchford"
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 (to either use one
or
"Rick Ratchford"
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 DIRECTION results. Once t
face-wrapper, released
under GPL - if that is of any help - but as I see it - that
would shift 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
"Christophe Leske" 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 24000 other
>
"lau stephen" schrieb
im Newsbeitrag
news:c26a05160906150443h44b8f434s46e6ab4215f61...@mail.gmail.com...
2009/6/14 Olaf Schmidt :
>> Each client could do (with a 1:10 relation of writes and reads)
>>
>> Loop 1000 times
>> With LoopCounter Modulo 7 (case-sw
"Olaf Schmidt" 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
Ok - make the loop-counter 7000 to reach the
result of 11 n
1 - 100 of 129 matches
Mail list logo
