FN-FORUM: php, XML, content and searching

date posted 4th September 2007 07:54

Hi Guys

Looking for some advice regarding using XML as a data source for website/s.

Currently all site data for a site builder CMS I have developed is held in
mySQL but I would prefer if it was stored in xml documents in the file
system and so I could do away with the database as primary content data
source.

My question is about searching the xml data, the sites have a search
facility using php/mySQL but I know very little about how to search through
an XML document or if there is a nice way of doing it via php.

My concerns are that all the xml data would have to be loaded into memory to
do the search is there an elegant way to do it? Or even a prebuilt xml
search component specific to the task etc maybe something that indexes a
defined set of xml data periodically or triggered from php and uses that
index as the data source much like it would in a mySQL database search.

The system would be used on 100's of websites at the same time so loading
all website content into memory for each site is not an option I don't
think.

I'm just researching options ATM so if anyone has any other cool ideas about
how to do this then I'm open to suggestions.

Regards
Sam Morgan
WiredEyes Media / ServWise Advanced Hosting

tel (Uk): +44 (0)20 7100 2178
tel (Italy): +39 070 773 6543
web : www.wiredeyes.com / www.servwise.com
----
umop ap!sdn w,! aw dlaH
----
====================================
Summer Sale 50% off all ServWise
hosting, use coupon code : HALFPRICE
====================================