Re: FN-FORUM: php, XML, content and searching

date posted 4th September 2007 10:46

Some of the points to be aware of: (may be biased towads java
programming language).

Please be aware that they are based on my experiences, (and experiences differ).

> In my opinion, XML is good if there is a data exchange involved with third parties, but not for use internally in *most* of the systems.

> You can query the XML data using either XPath expressions or using functions provided by jdom tree (dependnig upon the api you use). In any case, the XML would need to be loaded into memory, and all those DOM objects can take up awful lot of memory. So, make sure you have loads of memory, and that you test your applications under similar load. The query response times using XPath/jdom functions are quite good, but memory can be the killer.

> I have noticed that it is always best to leave the data as it is in the database, and let the application use it in a way, they see best. The rate of change of application technologies is much faster compared to the rate of change of database server technologies. So, you *may* want to use the same data in a different way in a separate system/application.

Thanks.



On 4 Sep 2007 08:49:38 -0000, Richard Fletcher [EMAIL REMOVED] wrote:
>
> kujo wrote:
> >
> > Hi
> >
> > You could still be using a main database for all the websites and pull
> > the data out of it into static XML files on a regular basis or when some
> > data is changed via your CMS and parse the XML remotely from each website.
> > I'd use PHP5 simpleXML methods and maybe some PEAR library for content
> > syndication, but I'm not sure what's your goal and which platform you're
> > on so it's just an idea.
>
> Just to add to my previous comment, php5's simpleXML and domXML
> extensions both use the same XML parsing library which means you can
> convert from one method of accessing the xml to the other without
> virtually any overhead. That is to say you don't need two copies of the
> data in memory.
>
> Regards
> Richard
>
> --
> Artumi Systems, 58 Salmon Street, Sheffield, S11 8DD.
> Tel 0114 250 7654, Web http://www.artumi.com
> VAT Reg 889 0317 88
>
> --
> Freelancers, contractors earn more with Prosperity4
> Call 0870 870 4414 or visit www.prosperity4.com
> and benefit from Inland Revenue approved expenses today.
>
> To advertise here: http://www.freelancers.net/advertising.html
>
>