Mysql Query vs XML Data in php -


We are building a website that will serve approximately 30k unique visitors a day. We currently connect a simple mysql & gt; A simple question & gt; Close mysql

I am afraid that we can open 1k mysql connection top with a dual core server running 2 GB RAM. Is 1k a good estimate?

Is cron job output XML files better, and does our PHP files pull data from them?

Normally XML data will never be faster than MySQL (i.e. performing queries).

I do not know what kind of data you have, but XML can only be faster if you have simple files and you do not need to search, just load the file and format it .

If you need to search, use MySQL MySQL optimizes all the types, for example it stores the main column in a separate file, which is too Allows for fast search.

Comments