Hello!
В сообщении от Monday 25 August 2008 02:18:56 Susan Ottwell написал(а):
> How would one insert rows randomly within a range of 1000 rows? I can
> easily enough do this in the script that calls the insert function,
> but it would be more efficient if I could use an sqlite function or
How would one insert rows randomly within a range of 1000 rows? I can
easily enough do this in the script that calls the insert function,
but it would be more efficient if I could use an sqlite function or
feature to do this.
sottwell
___
salutations,
I don't understand exactly what you
mean by "library project". is it a
"Win32 Static Library"?
do I create the library project and
include "sqlite3.c" in it?
in this way, will sqlite be integrated
in the application, instead of located
in an external DLL file?
note: I'm using Visual
Hello CAVALO,
Sunday, August 24, 2008, 12:12:05 PM, you wrote:
CS> salutations,
CS> so, I should just import the sqlite3.c file into
CS> the project, not linking to sqlite3.lib?
CS> is it necessary to #include this file in main.cpp,
CS> or do we only need to import it in the project?
CS> what
2008/8/24 Mihai Limbasan <[EMAIL PROTECTED]>:
> Bruno Moreira Guedes wrote:
>> And even with too many 'locking concurrency', I've done some stress
>> testing and SQLite still very well. I've thrown the SQLITE_BUSY errors
>> to a retry algorithm, which waits a random time in a time range and
>> try
salutations,
so, I should just import the sqlite3.c file into
the project, not linking to sqlite3.lib?
is it necessary to #include this file in main.cpp,
or do we only need to import it in the project?
what about sqlite3.h?
is just "sqlite3.c" necessary for this?
thank you in advance.
2008/8/10
Personal Oracle Database 10g Release 10.2.0.3.0
CREATE temp TABLE t1(a INTEGER, b INTEGER);
INSERT INTO t1 VALUES(1,2);
INSERT INTO t1 VALUES(9,8);
SELECT a AS b, b AS a FROM t1 ORDER BY a;
B A
-- --
1
Bruno Moreira Guedes wrote:
> And even with too many 'locking concurrency', I've done some stress
> testing and SQLite still very well. I've thrown the SQLITE_BUSY errors
> to a retry algorithm, which waits a random time in a time range and
> try again until a high number of retries. Using it,
On Sun, Aug 24, 2008 at 12:36 AM, Derek Developer
<[EMAIL PROTECTED]> wrote:
> Well that implies that the "parsing" decrypts each page in the database for
> each query. How else would it traverse a key that is encypted?
>
> Isn't that going to be very slow?
>
Are you thinking it needs to decrypt
Well that implies that the "parsing" decrypts each page in the database for
each query. How else would it traverse a key that is encypted?
Isn't that going to be very slow?
Cory Nelson <[EMAIL PROTECTED]> wrote: On Sun, Aug 24, 2008 at 12:07 AM, Derek
Developer
wrote:
> I am still not clear
On Sun, Aug 24, 2008 at 12:07 AM, Derek Developer
<[EMAIL PROTECTED]> wrote:
> I am still not clear if page level encryption permits equality searches and
> range searches?
> Intuitively it would seem that these searches would require every page to be
> decrypted to access the column data for
I am still not clear if page level encryption permits equality searches and
range searches?
Intuitively it would seem that these searches would require every page to be
decrypted to access the column data for each record...
unless a proxy Index is used as suggested here
12 matches
Mail list logo