# What is the better way? Array or MYSQL?

**URL:** <https://forum.kirupa.com/t/what-is-the-better-way-array-or-mysql/275080>\
**Category:** flash\
**Created:** [November 9, 2008, 2:46am UTC](https://forum.kirupa.com/t/what-is-the-better-way-array-or-mysql/275080 "2008-11-09T02:46:25Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Surekin](https://avatars.discourse-cdn.com/v4/letter/s/ebca7d/32.png) [@Surekin](https://forum.kirupa.com/u/Surekin)\
**Post date:** [November 9, 2008, 2:46am UTC](https://forum.kirupa.com/t/what-is-the-better-way-array-or-mysql/275080/1 "2008-11-09T02:46:25Z")

</div>

Hey!

The title sounds a bit wrong, but what i mean is:

If i have a database with many different entries and i collect the data into flash via XML what is the better way to sort it out? Is it easier to load different PHP/XML Files for every query i have or is it easier to load the whole database via one xml into an array and make the queries with that array?

by queries i mean f.e. Sort by Id, sort by date, select where id=something

easy to do for me with SQL/PHP, but i dont know (yet) how capable arrays are…  
What ways to you use?

Cheers