Re: Syncato 0.7

In reality the efficiency of that query isn't super important in the 
short term. Since you're posting infrequently, pretty much all of your 
requests will serve out of cache (that is actually always the case). 
The cost will only be a problem if you have a really slow machine and 
do a lot of posting or have a huge number of comments posted (i.e. 
thousands per day). It will also be a problem if you don't have enough 
memory to generate the initial cache entry.

I'm not saying that's an adequate solution going forward, but we 
definitely need to keep perspective over theoretical inefficiency vs. 
real world performance. We're talking about sites that even at their 
busiest serve maybe a few hundred thousand hits per day. When it needs 
to go beyond that I'm not at all concerned about the ability to make it 
scale.

So yeah it's inefficient, and will get more inefficient as time goes 
by, but right now that probably doesn't actually matter. As the 
supporting software matures the problem will be worked out. So if you 
want to have it work that way, just override front-page.xsl and make it 
use an embedded query instead of processing based off the incoming XML. 
Look at the RSS xsl files to see how they do embedded queries.


On Nov 25, 2003, at 7:39 PM, darryl wrote:

> Ok what that means is the MORE posts i have the less efficient the 
> query will be. Of course the hit really depends on my machine as well. 
> I guess
> the issue would be, if you post in spurts your front page would 
> grown/shrink erratically depending on your activity, and to reset the 
> configuration
> would be a pain... hmm....
>
> -darryl.
>
> Kimbro Staken wrote:
> There actually isn't any way to express that in just XPath, you'd have 
> to do it in XSL-T which means you'd have to retrieve all items and 
> then just pick off the number that you want. Yesterday I requested a 
> feature for DB XML to enable retrieving ranges of query results, that 
> would help quite a bit with this, otherwise it's quite inefficient.
>>
>> Right now if you post infrequently you should probably just increase 
>> frontpage-term from 7 days to something larger.
>>
>> On Nov 25, 2003, at 6:40 PM, darryl wrote:
>>
>>> I haven't looked myself but how trivial would it be to change the 
>>> xpath to retreive the last x posts for the main page instead of 
>>> posts from the last
>>> x days?
>>>
>>> i.e. I've been very busy lately and haven't posted much and now 
>>> there's like only 2 entries on my site and i can envision the query 
>>> returning 0.
>>>
>>> cheers,
>>> -darryl
>>>
>>> Kimbro Staken wrote:
>>>
>>>> Syncato 0.7 is now available. More information here: 
>>>> http://www.xmldatabases.org/WK/blog/1020_Syncato_0.7_Released.item
>>>>
>>>
>>>
>>
>> https://lists.sourceforge.net/lists/listinfo/syncato-general
>
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by: SF.net Giveback Program.
> Does SourceForge.net help you be more productive?  Does it
> help you create better code?  SHARE THE LOVE, and help us help
> YOU!  Click Here: http://sourceforge.net/donate/
> _______________________________________________
> Syncato-general mailing list
> Syncato-general-5NWGOfrQmneRv+LV9MX5uipxlwaOVQ5f@public.gmane.org
> https://lists.sourceforge.net/lists/listinfo/syncato-general
>
>
Kimbro Staken
Software, Consulting and Writing http://www.xmldatabases.org/
Apache Xindice native XML database http://xml.apache.org/xindice
XML:DB Initiative http://www.xmldb.org



-------------------------------------------------------
This SF.net email is sponsored by: SF.net Giveback Program.
Does SourceForge.net help you be more productive?  Does it
help you create better code?  SHARE THE LOVE, and help us help
YOU!  Click Here: http://sourceforge.net/donate/