On Sonntag, 30. Dezember 2007, Sergey Chernyshev wrote: <snip> > > In fact we have such a site, but it runs on a rather unstable hardware > > (we have a buggy RAID controller or driver :-(). It is our test server at > > test.ontoworld.org, which also was used for other experiments and is not > > in > > perfect shape right now (and querying was disabled in order to not impair > > other experiments). We might set up another more recent Wikipedia copy > > sometime in some future. > > Great, I'll definitely take a look. What were your main discoveries with > English WP and SMW? How many Semantic Templates did you make? I'd say that > I'm mostly interested in volume and performance on relatively simple > queries since this is what most of large projects would need, although > complex queries are also interesting.
Results of a small evaluation on this site are reported in [1]. The problem is that detailed results can change quickly with software versions (SMW changes of course, but MySQL also does). So things should be taken with a grain of salt. > > It would be quite interesting to see latest WP and latest SMW to understand > biggest pain-points. Biggest pain IMHO is unpredictability of query times. It turns out that most queries are rather fast even on big sites, while some are slow without apparent reasons. If we could just limit SQL-side query execution and report timeout errors if needed, things would be much simpler. But I do not know how to achieve that. Markus [1] http://korrekt.org/index.php/Semantic_Wikipedia_%28JWS2007%29 > > > > Since we're talking about performance, there is another side of > > > > performance > > > > > tuning - percepted performance, this mostly concerns javascripts, css > > > > and > > > > > so on - for example there is still a problem of SIMILE Timeline not > > > > being > > > > > that fast to load (although performance of pages that didn't have it > > > improved now, when client-side the code is loaded only on pages that > > > > need > > > > > it). This kind of issues can be tracked using Firebog with Yahoo's > > > YSlow add-on. > > > > True, and I hope Timeline is really the main performance problem there. I > > wonder whether we could ship a more stripped down version of the scripts > > to > > decrease load time. I guess we should ask the guys over at SAIL for that > > ... > > Can you describe modifications you made to original Timeline code? I used > it some time ago and took closer look at how their code is bundled, I might > be able to help to migrate it to new version. BTW, it might make sense to > have SMW code separate from theirs to make such upgrades easier. > > > > I'll be happy to run the tests on the system with significant amount of > > > data if you need a testbed. > > > > All profiling support is appreciated, but I am not sure how to > > operationalise > > testing on our servers (SQL profiling would probably need server access, > > which is not possible in this case). Insights on JavaScript performance > > are > > also useful, but I guess that MySQL tuning could be most important for > > approaching large sites. I you have know about DB optimisation, you can > > also > > have a look at our DB layout and at the SQL queries we generate > > (format=debug). > > Actually I was talking about standardizing some test process that all of us > can run on our servers to compare performance and settings and help each > other to derive best practices in terms of performance and maybe even find > bottlenecks. > > Sergey > > > Thanks, > > > > Markus -- Markus Krötzsch Institut AIFB, Universät Karlsruhe (TH), 76128 Karlsruhe phone +49 (0)721 608 7362 fax +49 (0)721 608 5998 [EMAIL PROTECTED] www http://korrekt.org
signature.asc
Description: This is a digitally signed message part.
------------------------------------------------------------------------- This SF.net email is sponsored by: Microsoft Defy all challenges. Microsoft(R) Visual Studio 2005. http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________ Semediawiki-devel mailing list Semediawiki-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
