SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Member
    Join Date
    Apr 2011
    Posts
    4
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Use XML or MySQL Database?

    Hi,

    I am currently working on a website that will solely rely on XML files for its content (display only) - listings,filtering etc. Each XML file is equal to one record. These files are then compressed to a single zip file per day from another FTP server which I download them from. So this means there are thousands of XML files currently generated.

    I just would like to ask for the best way to handle the data. Is it faster to create a script to import them to a database first? Then check daily for a new zip file and insert it into the database. Or just directly get data through the XML files?

    On both methods I would think that it will require me to extract all the zip files first?

    You input is very much appreciated.
    Thanks!

  2. #2
    SitePoint Enthusiast
    Join Date
    Mar 2010
    Posts
    38
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I think you have to use Database. If the are going to process huge data then better go for database.


Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •