Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
  • 한국 커뮤니티
0

xml file usage

Explorer ,
Jul 28, 2009 Jul 28, 2009

A customer of mine is using a custom made Real Estate management software which extracts the properties' relevant data to an xml file of about 700.000 lines. I will create a website which will give the website visitor the ability to search for the available properties. I am not sure about which is the best way to manage the xml file. Should I use it natively and run the search queries on it? Should I export the data to an MS SQL Server database and run the queries on the database? I have never worked with XML before so I do not have a clue. Of course I would prefer to use the power of coldfusion.

The xml file attached...

Thanks in advance...

488
Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Participant ,
Jul 28, 2009 Jul 28, 2009
LATEST

I would recommend putting it into a database.  An XML file that big will not perform well.

Translate
Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
Resources