Since Fossil was founded and is developed by drh as well, this step was
not that unpredictable.
If you compare the forum to the mailing list the only drawback I can see
is that one is no longer able to contribute via mail:
| Mailing list | Forum
---+--+-
On 8/30/19 3:59 AM, dirdi wrote:
> Do not bother!
- "bother!"
+ "worry!"
Sorry @Keith, English is only a second language to me and sometimes I
mix-up idioms. You all were very helpful and I learned a lot so far. I
just feel a bit dumb right now =/
t; < INSERT INTO space_used
>> VALUES('idx_words1','words',1,0,551407,550067,3,3826907,0,0,7,6,1341,0,5816,14208,0,1282,5517312);
>> 1270a1270
>>> INSERT INTO space_used
>>> VALUES('idx_words1','words',1,0,551407,550067,3,
I am happy to provide
additional information.
--
Best regards
dirdi
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
1 22 0 01
> Also, what version of SQLite3 are you using?
> SELECT sqlite_version();
returns
> 3.29.0
Packages installed on my dev machine:
> $ dpkg-query -l "*sqlite*"
> Desired=Unknown/Install/Remove/Purge/H
On 8/29/19 9:35 PM, Simon Slavin wrote:
> On 29 Aug 2019, at 8:12pm, dirdi wrote:
>
>> The only difference between both runs:
>
> Well, that's nothing. I see no reason for the massive change in timing from
> what you posted. But someone else might.
Well the
once afterwards:
> $ ./sqlite3_analyzer db.sqlite3 > run2
The only difference between both runs:
> $ diff run1 run2
> 1260d1259
> < INSERT INTO space_used
> VALUES('idx_words1','words',1,0,551407,550067,3,3826907,0,0,7,6,1341,0,5816,14208,0,1282,5517312);
> 12
dex, what is the
> result?
If I run ...
> ANALYZE;
> REINDEX;
> ANALYZE;
... instead of ...
> DROP INDEX `idx1`;
> CREATE INDEX `idx1` ON `tbl1` (
> `int`
> );
the UPDATE query remains being slow (~36m).
--
Best regards
dirdi
_
Hi there, I noticed some - at least for me - unexpected behavior of the
REINDEX command:
I have a DB with 7 tables, 11 indexes and a size of about 140MiB. The DB
is generated by a python script parsing an XML file. Entries are added
to the tables in arbitrary order.
After the tables have been cre
9 matches
Mail list logo