Mysql Query vs XML Data in php

Question

We are building a website which would serve about 30k unique visitors a day. Currently we use a simple mysql Connect > A Simple Query > mysql Close.

I'm afraid that with a dual core server running 2GB of RAM we would be able to open about 1k mysql connection tops. is 1k a good estimate?

Is it better to make a Cron-Job output XML files and let our php files grab the data from them?

Can you elaborate on the file cache, i'm coming from a programming environment and have little clue about how to set up such a thing — Tom
– Tom, Commented Mar 16, 2011 at 20:29
one suggestion below, there's a few other about, just google php cache — user557846
– user557846, Commented Mar 16, 2011 at 20:37

Martin Tournoij · Accepted Answer · 2011-03-16 20:40:03Z

2

Typically XML will never be faster than MySQL for searching data (i.e. performing queries).

I don't know what kind of data you have, but XML will only be faster if you have a bunch of simple files and don't need to search, just load the files and format them.

If you need to search, then use MySQL. MySQL does all sorts of optimizations. For example it stores KEY columns in a separate file, allowing for a much faster search.

answered Mar 16, 2011 at 20:40

Martin Tournoij

28k24 gold badges110 silver badges158 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Tom Over a year ago

no need for search. the XML file would be exactly what i need, simple xml loading & listing results using a For Each loop

Martin Tournoij Over a year ago

Then using XML files may be faster. No guarantees though, remember MySQL also does caching -- You can write a script/daemon to cache stuff, but then you might be better off with MySQL And MEMORY tables .... As a sidenote, if you only have "flat" data and no need for XML's nesting features, you'll be better of with CSV IMHO. PHP provides fgetcsv() and fputscsv().

anubhava · Accepted Answer · 2011-03-16 20:33:03Z

0

I would suggest using Zend cache for caching MySQL query results for the the data that doesn't change frequently.

answered Mar 16, 2011 at 20:33

anubhava

790k67 gold badges603 silver badges671 bronze badges

Collectives™ on Stack Overflow

Mysql Query vs XML Data in php

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related