Jason Tudor wrote:
>
> In order to get the count from a particular table, I could do the following:
>
> SELECT COUNT id FROM main.table UNION
> SELECT COUNT id FROM db2.table
>
> I would then step through the result and add the two values to get a total
> count.
That would not be the optimal use
Igor Tandetnik wrote:
Martin Pelletier wrote:
Is there a similar function that
would place the result of a query in memory just like SQL3_get_table but
their stored type (integer, float, etc), with perhaps a header to
indicate
what type the data should be read as?
With SQLite's manifest
Hello,
I am using an SQLite to host data for various projects, some of which
take up significant place with some large monolithic tables (around 750
MB). Querying goes through the DLL using a call to SQLite3_get_table.
The function allocates memory space to record the table in chars, even
if
[EMAIL PROTECTED] wrote:
Martin Pelletier <[EMAIL PROTECTED]> wrote:
Hello,
I am trying to optimise an SQLite database running on Windows. One of
the things I'm looking at is page size. However, a page on sqlite.org
(http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningW
Hello,
I am trying to optimise an SQLite database running on Windows. One of
the things I'm looking at is page size. However, a page on sqlite.org
(http://www.sqlite.org/cvstrac/wiki?p=PerformanceTuningWindows) mentions
this:
"Just a note that you must also perform this command [PRAGMA
This is news to me. Why can't SQlite use more than one index?
Samuel R. Neff wrote:
afaik SQLite will only use one index per table
--
Martin Pelletier
Informatique / Software Development
Infodev Electronic Designers International Inc.
Tel : +1 (418) 681-3539, poste /ext. 114
Fax : +1 (418
I use a twist on the various versions listed so far: "es cue el-ait".
Hearing "sequel" for SQL always makes me cringe.
Dennis Cote wrote:
I have a simple question; how do you pronounce SQL and SQLite?
--
Martin Pelletier
Informatique / Software Development
Infodev
7 matches
Mail list logo