18 Aug
2011
18 Aug
'11
5:05 p.m.
On 08/18/2011 10:56 AM, Paul Libbrecht wrote:
Le 18 août 2011 à 16:42, Sergiu Dumitriu a écrit :
Yes, writing is a bit slowed down, but with a very big improvement in
terms of querying. Given that there are many more searches than writes,
and the write slowdown is in term of milliseconds while the query
speedup is in term of seconds, or even minutes when the database grows
larger, it is definitely a good trade-off.
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
Personally, I think that the index on
xwikilargestrings(xwl_value) is
not needed, but for all the other types of values they are useful.
Thanks Sergiu,
I think I agree with your analysis and I thank you for the 50 chars definition which is
certainly a safe limit.
Do I also understand that writing is then slowed down?
(such a b-tree would have quite many nodes, max 26^50, or? considering the entropy it
might be big)