Thanks for the info.
Actually the MySQL version I mistyped it is 5.0.45 not 6.0.45
I'll see if I can update PHP sometime.
Cheers,
Gu
btw I solved my specific original problem by avoiding any objects and therefore
memory leaks altogether.
Quoting CNIT <c...@uniyar.ac.ru>:
>
> > Hi,
> >
> > I wonder if anyone can tell me if the functions used when I call
> > SMWQueryProcessor::getResultFromQueryString should release all the memory
> after
> > they finished?
> >
> > I thought I could avoid a memory problem by calling
> getResultFromQueryString
> > with different 'offset' values to retrieve smaller chunks of articles.
> However,
> > at some point I still run out of memory during the loop, even if I just
> call the
> > function and ignore the result.
> >
> > $maxresults = 500;
> > $limit = $params['limit']; # is 10
> > for ($ofs = 0; $ofs < $maxresults ; $ofs += $limit) {
> > $params['offset'] = $ofs;
> > $dummy = SMWQueryProcessor::getResultFromQueryString($querystring,
> > $params, $printouts, SMW_OUTPUT_WIKI);
> > }
> >
> > When $ofs reaches 490 I run out of memory (Fatal error: Allowed memory size
> of
> > 134217728 bytes exhausted).
> >
> > The test query is '[[MyProp::~*;?;?]][[Category:MainArticle]]' with about
> 19000
> > articles matching (as using [[MyProp::?;?;?]] gives the error 'The value
> of
> > property "MyProp" was not understood', I have to replace one '?' with
> '~*').
> >
> > MediaWiki 1.13.1
> > PHP 5.2.1
> > MySQL 6.0.45
> > SMW 1.5a SVN
> >
> > Thanks,
> > Gu
> >
> Hi!
> By the way, from the linux admin point, you have not very stable
> versions of PHP and MySQL.
> I believe that mediawiki users had generally stayed away from PHP 5.2.x
> branch until recent
> releases (5.2.6, 5.2.8).
>
> Is MySQL 6.x already stable enough? Some time ago it was still
> experimental, probably
> also introducing new not throuthly tested DB engine..
>
> (I am doing very different things right now, but still hoping to build
> another SMW site in
> some time)..
> Dmitriy
>
------------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It is the best place to buy or sell services for
just about anything Open Source.
http://p.sf.net/sfu/Xq1LFB
_______________________________________________
Semediawiki-devel mailing list
Semediawiki-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/semediawiki-devel
