a speed question

gingar

Hi guys.

Here's the scenario.

I'm pulling info (property details) from 4 different xml sources. The sources may contain the same property, but different details, say for example, source A has got phone numbers of property A, source B has got addresses and emails of property A, source C has got images of property A etc. I need to combine them and display them uniformly on my site.

Like
property A,
address,
phone,
email,
image etc,

instead of

property A,
phone

property A,
address,
email

property A,
image

Besides this combining of details, I also need to be able to sort the list by alphabetical order, as well as value of the property.

Would inserting into a temporary table and retrieving the data be faster?
Or would assigning everything into a multi-dimensional array, and using array sorting be faster for displaying purposes?

The data can be 1 record or up to 300 records..

Also, which one will be able to facilitate paging better?

Any one able to suggest anything? Or has anything better in mind? Please guide me!

Thanks!

djjjozsi

Database? 🙂

if i were you i've rather use database then xml..

Then you can easily create properties of selects. The properties might stored in a single array with the labels.
I could make a video tutorial about the basic database how-to's

...the order, pagings is easier in database.

gingar;10892094 wrote:
Hi guys.

Here's the scenario.

I'm pulling info (property details) from 4 different xml sources. The sources may contain the same property, but different details, say for example, source A has got phone numbers of property A, source B has got addresses and emails of property A, source C has got images of property A etc. I need to combine them and display them uniformly on my site.

Like
property A,
address,
phone,
email,
image etc,

instead of

property A,
phone

property A,
address,
email

property A,
image

Besides this combining of details, I also need to be able to sort the list by alphabetical order, as well as value of the property.

Would inserting into a temporary table and retrieving the data be faster?
Or would assigning everything into a multi-dimensional array, and using array sorting be faster for displaying purposes?

The data can be 1 record or up to 300 records..

Also, which one will be able to facilitate paging better?

Any one able to suggest anything? Or has anything better in mind? Please guide me!

Thanks!

gingar

oh, the xml sources are not under my control.. .

and i have to pull from the xml sources cause certain info are real time..

so database would be faster than array?

djjjozsi

i think yes.

if you get an entry from a database, you didn't need to select the whole table, just what you need.
if i had to make this job, i were do an xml -> database program, i store the xml files and their last update date, and if there is something new in the xml, i insert/update the data into database.

To select/search/insert/delete is faster with database, you could make relations easier.

how otfen changes these xml files ?

gingar;10892463 wrote:
oh, the xml sources are not under my control.. .
and i have to pull from the xml sources cause certain info are real time..
so database would be faster than array?

Weedpacket

gingar wrote:
Would inserting into a temporary table and retrieving the data be faster?
Or would assigning everything into a multi-dimensional array, and using array sorting be faster for displaying purposes?

Are you storing these for later, or are you just displaying them on the fly? If you're storing them then you'll need a database of some description to store them in. If you're not storing them then there's no point using a database, because if you put them in a temporary table you're only going to have to get them out again immediately afterwards.

gingar

djjjozsi,
the xml changes are not within my control, from third party, i assume it could be anything between 1 min and 20mins?

Weedpacket,
i'm displaying them on the fly.. so adding to temporary database is not feasible?

oh dear.. any ideas?