hello,
in heavy multithread environnmeent we receive (one time a month, so not
very often), this error :
Access violation at address 6090B662 in module 'sqlite3.dll'. Read of
address DE8D6B84
any idea ?
___
sqlite-users mailing list
it's not enalf :(
On 1/14/2011 1:48 AM, Jean-Christophe Deschamps wrote:
>> when i just launch th application, at the beginning the query can take
>> around fews seconds... but after some time (10 - 20 minutes), it's take
>> only few ms !
>>
>> so i guess it's because the windows cache in memory
hello,
when i just launch th application, at the beginning the query can take
around fews seconds... but after some time (10 - 20 minutes), it's take
only few ms !
so i guess it's because the windows cache in memory the database file ?
so how to speed up this time to make windows cache more
hello,
i want to update a column name in a table, but the only way for that is
to redo the table
the table have around 15 000 000 records
so i do like this :
ALTER TABLE PICTURE_HASH_ID RENAME TO PICTURE_HASH_ID_OLD;
DROP INDEX PICTURE_HASH_ID_PIC_IDX;
CREATE TABLE PICTURE_HASH_ID(
HASH_ID
> Select
>H1.ID
> from
>HASH1 H1
> where
>x1_y1 BETWEEN min11 AND max11 AND
>x1_y2 BETWEEN min12 AND max12 AND
>x1_y3 BETWEEN min13 AND max13 AND
>x1_y4 BETWEEN min14 AND max14 AND
>x1_y5 BETWEEN min15 AND max15;
>
>
no it's not work at all !! without an rtree index
i do it.. but it's change nothing :(
On 12/24/2010 3:47 PM, Simon Slavin wrote:
> On 24 Dec 2010, at 8:17am, Vander Clock Stephane wrote:
>
>> I have a key like this
>>
>> 123-098-230-120-111 where (123), (098), (230), (120), (111) are what i
>> call node
>>
can you gave me the name of a good SSD you advise me to buy ?
i decide to make a try !
Thanks again
stéphane
On 12/24/2010 12:24 AM, John Drescher wrote:
> On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane
> <svandercl...@yahoo.fr> wrote:
>> that very very much expensi
> Can you describe what you're trying to do with that command ?
of course !
I have a key like this
123-098-230-120-111 where (123), (098), (230), (120), (111) are what i
call node
Node are integer comprise between 0 and 255 (bytes)
and i need to found "similare" key.
A similar key is a key
you are working with real geospatial data such as Imagery or vector
> data, there are many applications that may be suited for these calculations.
>
> Spatialite is a Sqlite extension that has spatial indexes(rtree) and spatial
> functions such as buffer, intersect,etc
>
>
>
that very very much expensive :( how much you thing ?
On 12/23/2010 11:55 PM, John Drescher wrote:
>> i m affraid so ... but what it's will be with 50 000 000 rows ? i don't
>> have 100 gigabytes of memory :(
> I would get a 256GB SSD.
>
> John
> ___
i don't know but i quite sure not, because the cost to update all the
row in the table Hash will be much much (much) more expensive ...
and also this solution it's absolutely not multi thread :(
On 12/23/2010 11:46 PM, stormtrooper wrote:
> would it run faster if you add two columns to the Hast
> Right. So you have a database with 2 000 000 rows that is 1.8GB
> So your first 1 000 000 rows takes up about 1GB.
> And your test case with just 1 000 000 rows in runs really fast.
>
> So what is happening is that most of the first 1 000 000 rows fits in memory.
> Once the database gets
Windows 2008 R2 with 8GB of memory.
but actually i run the test on a beta server with only 1Gb of memory and
win2003 ..
the database si with 2 000 000 rows is 1.8 GO
thanks by advance !
stéphane
On 12/23/2010 10:52 PM, Simon Slavin wrote:
> On 23 Dec 2010, at 7:36pm, Vander Clock Steph
r of them have been done, some/much of the file might
> be in OS file cache memory, and selects are then hitting memory instead of
> the much slower disk.
>
> Doug
>
> -Original Message-
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sqli
hello,
why, on a big table (+5 000 000 rows with RTREE ndex) at the beginning,
the select is very slow to return (2-5 secondes), but after 1000 selects,
it's start to return immediatly (10 ms) ??
thanks by advance
stéphane
___
sqlite-users mailing
gt; See http://www.sqlite.org/rtree.html
>
> On Wed, 2010-12-08 at 19:56 +0300, Vander Clock Stephane wrote:
>> Hello,
>>
>> on the table :
>>
>> CREATE TABLE HASH(
>> ID INTEGER PRIMARY KEY ASC,
>> x1_y1 INTEGER,
>> x1_y2 INTEGER
I know this trick, but it's a little longer to do than simply manually
increate the file DB size ?
my test show it's work, i m just currious why we can not do like this ?
thanks again
stéphane
On 12/11/2010 3:44 AM, Max Vlasov wrote:
> On Sat, Dec 11, 2010 at 1:52 AM, Vander Clock Steph
:
> On Fri, Dec 10, 2010 at 11:20 PM, Vander Clock Stephane<
> svandercl...@yahoo.fr> wrote:
>
>> Hello,
>>
>> to limit the file fragmentation i want to increase the size of the
>> database file (with the windows API function).
>>
>> Can i do this ?
>
ter
> between d and i, second letter between t and v, third letter between f
> and k and so on. How would you search for these phones? It's pretty
> complicated stuff and wasn't included in SQLite because it's Lite.
>
>
> Pavel
>
> On Fri, Dec 10, 2010 at 3:18 PM, Vander
but i try and it's seam to work ?
i simply increase manually the size of the database and it's seam to
work ???
can you confirm that it's not possible because here it's work ?
> Wait until your data file is large enough, then use any OS tool to
> defragment it :)
that a big mistake, because
Hello,
to limit the file fragmentation i want to increase the size of the
database file (with the windows API function).
Can i do this ?
thanks you by advance
stéphane
___
sqlite-users mailing list
sqlite-users@sqlite.org
not work :(
it's sad that this simple select is not possible under sqlite3 :(
On 12/10/2010 6:11 PM, Jim Morris wrote:
> Did you try a compound index?
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
>
> I usually seem to be wrong when I try to help here, but I keep trying.
>
> My guess is that SQLite uses only one index per query (or per table per
> query or something like that), and so has to do a whole bunch of full
> table scans (or at least full scans of the remaining rows).
>
huum if
ok i will try
On 12/9/2010 9:33 PM, Richard Hipp wrote:
> On Thu, Dec 9, 2010 at 11:27 AM, Vander Clock Stephane<
> svandercl...@yahoo.fr> wrote:
>
>> no one have an idea how to do such query ??
>>
> You can try building with SQLITE_ENABLE_STAT2 and then running
> I can't solve your problem but I have observations. I don't see how any SGDB
> (or RDBS as we call them) could do this quickly without lots of indexes.
>
but they do :( Firebird for exemple ...
> Your long SELECT command is something I would probably do in my programming
> language instead
> If you have another situation,
> wit same amount of data,
> which returns immedialty,
> than either situation is not the same,
> or you are making an error.
>
same situation (same amount of data) but on other SGBD like Firebird.
the result
return imediatly. on sqlite3 it's take hours :(
>
no one have an idea how to do such query ??
thanks
stéphane
On 12/8/2010 7:56 PM, Vander Clock Stephane wrote:
> Hello,
>
> on the table :
>
> CREATE TABLE HASH(
> ID INTEGER PRIMARY KEY ASC,
> x1_y1 INTEGER,
> x1_y2 INTEGER,
> x1_y3 INTEGER,
>
Hello,
on the table :
CREATE TABLE HASH(
ID INTEGER PRIMARY KEY ASC,
x1_y1 INTEGER,
x1_y2 INTEGER,
x1_y3 INTEGER,
x1_y4 INTEGER,
x1_y5 INTEGER,
x2_y1 INTEGER,
x2_y2 INTEGER,
x2_y3 INTEGER,
x2_y4 INTEGER,
x2_y5 INTEGER,
x3_y1 INTEGER,
x3_y2 INTEGER,
x3_y3
>> Some pragma are set be connection,
>> some by database (and all the connection to this database) and
>> some by the engine (all database and all connections)
> Could you give an example of this last category? I don't see by what possible
> mechanism could a PRAGMA issued in one process
Hello,
what are the concequence to use a page size of 512 bytes on a
hard drive with a cluster size of 64kb ?
thanks by advance
stéphane
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Hello,
our database have around 50 millions rows
the database have only one table with singleton value name(int)=valuet(int)
the database will be store in an hardrive formatted with cluster of 64kb (but
we can format
it with lower if neccessary)
the database must use the minimal neccessary
thanks !
On 11/22/2010 4:23 PM, Igor Tandetnik wrote:
> Vander Clock Stephane<svandercl...@yahoo.fr> wrote:
>> i want to use the pragma command to setup the page size. however they say :
>> "The page size may only be set if the database has not yet been created.&qu
Hello,
i want to use the pragma command to setup the page size. however they say :
"The page size may only be set if the database has not yet been created."
but how to do because as soon as i do sqlite3_open_v2 then the database
is created ?
and to execute the pragma i need connection to the
Hello,
just to say you that the doc probably want to say :
If the 3rd parameter to sqlite3_open_v2() is not one of the combinations
shown above or *NOT* one of the combinations
shown above combined with the SQLITE_OPEN_NOMUTEX,
SQLITE_OPEN_FULLMUTEX, SQLITE_OPEN_SHAREDCACHE and/or
34 matches
Mail list logo