Re: [sqlite] SQLite server

"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, >

Re: [sqlite] beginner

On 24 Dec 2010, at 2:05am, Bob Keeland wrote: > Is there anything like SQLite-Manager that works for those of us who still > use Microsoft software? I would suggest you download and install FireFox even if you intend to keep using Internet Explorer for your normal web browsing. The two

Re: [sqlite] beginner

On SQLite I see lots of complex questions and equally complex answers posted by people who obviously know what they are doing. I, however, still need to learn the basics of using SQLite. Is there anything like SQLite-Manager that works for those of us who still use Microsoft software? I'm

Re: [sqlite] how to speed up this ?

hmmm, how spatial index can help me better than sqlite Rtree index ? i just need to do Select H1.ID from HASH1 H1 where x1_y1_min>= x and x1_y1_max<= y and x1_y2_min>= z and x1_y2_max<= w and x1_y3_min>= a and x1_y3_max<= b and x1_y4_min>= c and

Re: [sqlite] how to speed up this ?

On 23 Dec 2010, at 8:19pm, Vander Clock Stephane wrote: > in my test all the random are different ... Can you describe what you're trying to do with that command ? Or can anyone else explain to me what Stephane is trying to do ? I don't see the point of a construction like this Select

Re: [sqlite] tcl and NULL

IMO the best solution is to have a special procedure passed to the Tcl SQL function that must be called to set the return value of the SQL function. Nico -- ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to speed up this ?

I'd be surprised if you run out of memory, updating a field, even with a 50,000,000 row table. Also, if 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

Re: [sqlite] how to speed up this ?

On Thu, Dec 23, 2010 at 4:06 PM, Vander Clock Stephane wrote: > that very very much expensive :( how much you thing ? > $500 to $600 US. John ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] how to speed up this ?

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 > ___

Re: [sqlite] how to speed up this ?

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

Re: [sqlite] how to speed up this ?

> 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 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] how to speed up this ?

would it run faster if you add two columns to the Hast table - randmax and randmin update Hash set randmax = max((<#randomnumber> % 255)-10,0) update Hash set randmin = min((<#randomnumber> % 255)+10,255) CREATE INDEX HASH_RMIN_IDX ON HASH (RANDMIN); CREATE INDEX HASH_RMAX_IDX ON HASH

[sqlite] tcl and NULL

While DRH is technically correct, it is possible to use coding convention to drive a solution ... trivially: $ tclsh8.5 % proc x {} { return NULL } % puts [x] NULL for instance: % proc recode { val } { set ret $val if { [string bytelength $val] == 0 } { set ret NULL }

Re: [sqlite] how to speed up this ?

> 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

Re: [sqlite] how to speed up this ?

On 23 Dec 2010, at 7:56pm, Vander Clock Stephane wrote: > 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 Right. So you have a database with 2 000 000 rows that is

Re: [sqlite] how to speed up this ?

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 Stephane

Re: [sqlite] how to speed up this ?

On 23 Dec 2010, at 7:36pm, Vander Clock Stephane wrote: > when their is lower than 1 000 000 row it's return in lower than 10 ms > with more than 1 000 000 row it's return with around 350 ms :( > and i need more than 50 000 000 rows :( :( How much memory do you have in that computer ? What

Re: [sqlite] beginner

Srinidhi, I recommend Sqlite-manager, a free tool which runs inside Mozilla FireFox, to help build your queries and view the table,rows, etc. http://code.google.com/p/sqlite-manager/ Keith -- View this message in context: http://old.nabble.com/beginner-tp30480116p30523978.html Sent from

Re: [sqlite] fill in blank fileds

On 23 Dec 2010, at 12:19am, Mark wrote: > ran the first example, came back with lots of lines, second test with the > just the 10 returned > 9 lines as 0: the second line as 2:3832, don't understand the > purpose/meaning of this If that's 2 in the first column then those fields which you

Re: [sqlite] 3.7.4 possible restore bug

On Thu, Dec 23, 2010 at 3:10 PM, Max Vlasov wrote: > Hi, > I experimented with artificial power loss (using hd box) and 3.7.4 both > library and shell didn't restore the files to the initial state. 3.6.10 > restores successfully. I don't know whether it's related the the

[sqlite] 3.7.4 possible restore bug

Hi, I experimented with artificial power loss (using hd box) and 3.7.4 both library and shell didn't restore the files to the initial state. 3.6.10 restores successfully. I don't know whether it's related the the contents of the file, but here the db files:

[sqlite] fill in blank fileds

Hi Simon, ran the first example, came back with lots of lines, second test with the just the 10 returned 9 lines as 0: the second line as 2:3832, don't understand the purpose/meaning of this Hi Igor, not checking for, want to fill in/replace blank or null fields with at least one character

[sqlite] Optimizing queries using RTrees

I have created an RTree table with the command CREATE VIRTUAL TABLE AirspaceRTree USING rtree (ID,MinLatitude,MaxLatitude,MinLongitude,MaxLongitude,MinAltitude,MaxAltitude); Furthermore, I have a table Airspace. The contents besides the ID (primary key) are irrelevant for this context. When

[sqlite] Segfault with FTS and tokenize=icu

Hi, This will crash SQLite 3.7.4 and 3.6.22: CREATE VIRTUAL TABLE f USING fts3 (t TEXT, tokenize=icu); insert into f (docid) values (1); insert into f (docid) values (2); insert into f (docid) values (3); insert into f (docid) values (4); update f set t = 'test' where docid = 3; Here is the