willpower Posted August 15, 2007 Share Posted August 15, 2007 Hi Just wanted some opinions here if you would. I have been asked to develop a site for a recruitment company. Clearly this will hold all their job vacancies. Now the software they use generates an XML file with approx 128 child nodes per Job node. What is normal practice here. Would you guys keep parsing the XML with every job in it instead of using a DB or would you wite a script that checks the XML for changes and updates a DB every so often and parse the DB for your webinfo Whats the overhead differences when it comes to processor load? Any hints, help, opinions or advice greatly appreciated Thanks as ever Will Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/ Share on other sites More sharing options...
dbo Posted August 15, 2007 Share Posted August 15, 2007 That seems like a relatively small XML file so you're not going to be out much processing time... and with XML you don't have to mess with database connections. Personally I like to use XML to interface different applications together and databases to maintain collections of data in logical manners. Also anytime security is a big concern I almost always go the database route. But in this case I'd say you're fine to continue parsing the XML. Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-324216 Share on other sites More sharing options...
willpower Posted August 15, 2007 Author Share Posted August 15, 2007 128 nodes multiplied by (unkonwn) job quantity...not sure how to determine waht a large XML file is and wher it becomes a hinderance to performance. Thanks for your comments. Has anyone done somethng similar on a recruitment site perhaps? Barand..where are you when i need you? Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-324224 Share on other sites More sharing options...
dbo Posted August 15, 2007 Share Posted August 15, 2007 Oh... I misread it. Yeah that sounds pretty large I'd database that badboy. Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-324227 Share on other sites More sharing options...
willpower Posted August 15, 2007 Author Share Posted August 15, 2007 Thanks again for your comments. Any more opinions out there on this project Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-324230 Share on other sites More sharing options...
willpower Posted August 15, 2007 Author Share Posted August 15, 2007 anyone else? Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325175 Share on other sites More sharing options...
plutomed Posted August 15, 2007 Share Posted August 15, 2007 Well I don't use XML so I'd use a db Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325188 Share on other sites More sharing options...
willpower Posted August 15, 2007 Author Share Posted August 15, 2007 thanks for that enlightened and informative response...lol Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325193 Share on other sites More sharing options...
plutomed Posted August 15, 2007 Share Posted August 15, 2007 Well I find dbs a lot easier to use Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325195 Share on other sites More sharing options...
willpower Posted August 15, 2007 Author Share Posted August 15, 2007 has anyone any informed opinions? Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325261 Share on other sites More sharing options...
dbo Posted August 16, 2007 Share Posted August 16, 2007 I guess my opinion sucks! Quote Link to comment https://forums.phpfreaks.com/topic/64971-xml-v-database/#findComment-325320 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.