[prev in list] [next in list] [prev in thread] [next in thread] 

List:       kde-panel-devel
Subject:    Re: Activities - Storing ResourceScoreCache in Nepomuk
From:       Vishesh Handa <me () vhanda ! in>
Date:       2013-05-28 9:43:00
Message-ID: CAOPTMKCf0vqJhLvEiAqrN5cuNEE_4a8mR6Efa+H_MBZLEJrHvQ () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


On Tue, May 28, 2013 at 2:44 PM, Ivan Čukić <ivan.cukic@kde.org> wrote:

>
> > I'm obviously still in favour of scrapping the code or at least disabling
> > it for 4.11
>
> I'm leaning towards that decision as well - disabling until we start really
> using it somewhere.
>

Do you want me to provide a patch?


> One thing I wanted to ask you - did you do some benchmarks about how much
> virtuoso slows down when the database gets twice as big? (from my pov, if
> the
> performance is drastically changed, it means either that the tables are not
> properly indexed or that virtuoso is crap :) )
>

Virtuoso is meant to scale so I doubt the performance will be that bad. It
depends on the kind of query.

The main problem is the lack of indexes for literal terms. Since all the
"objects" in a statement are stored in the same column, we cannot have
specialized indexes for dates, integers, etc. So when doing a search
through for a certain date range and other similar stuff, it is doing a
manual scan.

Also, virtuoso never removes its indexes. It only updates them, cause in
the "semantic word" deletions are very rare.


> Cheerio,
> Ivan
>
>
> --
> Money can't buy happiness, but neither can poverty.
>   -- Leo Rosten
>
> _______________________________________________
> Plasma-devel mailing list
> Plasma-devel@kde.org
> https://mail.kde.org/mailman/listinfo/plasma-devel
>
>


-- 
Vishesh Handa

[Attachment #5 (text/html)]

<div dir="ltr"><br><div class="gmail_extra"><br><br><div class="gmail_quote">On Tue, \
May 28, 2013 at 2:44 PM, Ivan Čukić <span dir="ltr">&lt;<a \
href="mailto:ivan.cukic@kde.org" target="_blank">ivan.cukic@kde.org</a>&gt;</span> \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"><div class="im"><br> &gt; I&#39;m obviously still in \
favour of scrapping the code or at least disabling<br> &gt; it for 4.11<br>
<br>
</div>I&#39;m leaning towards that decision as well - disabling until we start \
really<br> using it somewhere.<br></blockquote><div><br></div><div>Do you want me to \
provide a patch?<br> <br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex"> <br>
One thing I wanted to ask you - did you do some benchmarks about how much<br>
virtuoso slows down when the database gets twice as big? (from my pov, if the<br>
performance is drastically changed, it means either that the tables are not<br>
properly indexed or that virtuoso is crap :) \
)<br></blockquote><div><br></div><div>Virtuoso is meant to scale so I doubt the \
performance will be that bad. It depends on the kind of query.<br><br></div><div>The \
main problem is the lack of indexes for literal terms. Since all the \
&quot;objects&quot; in a statement are stored in the same column, we cannot have \
specialized indexes for dates, integers, etc. So when doing a search through for a \
certain date range and other similar stuff, it is doing a manual scan.<br> \
<br></div><div>Also, virtuoso never removes its indexes. It only updates them, cause \
in the &quot;semantic word&quot; deletions are very rare.<br><br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

<div class="HOEnZb"><div class="h5"><br>
Cheerio,<br>
Ivan<br>
<br>
<br>
--<br>
Money can&#39;t buy happiness, but neither can poverty.<br>
   -- Leo Rosten<br>
</div></div><br>_______________________________________________<br>
Plasma-devel mailing list<br>
<a href="mailto:Plasma-devel@kde.org">Plasma-devel@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/plasma-devel" \
target="_blank">https://mail.kde.org/mailman/listinfo/plasma-devel</a><br> \
<br></blockquote></div><br><br clear="all"><br>-- <br><span \
style="color:rgb(192,192,192)">Vishesh Handa</span><br> </div></div>



_______________________________________________
Plasma-devel mailing list
Plasma-devel@kde.org
https://mail.kde.org/mailman/listinfo/plasma-devel


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic