db or array sorting faster?

gingar

Hi Guys,

Im retrieving real time data via xml from another server, formatting it, sorting it, then displaying it. Its taking ages to format, sort and display the data, about 1+min, cause according to the server people, the compressed xml data only took 15 secs to return.

At present, I'm looping through the compressed data, inserting them into 4 different arrays based on different criteria.

Before displaying the data, I used

sortmddata()

to sort the 4 individual data alphabetically.

I then loop through each array to display.

How can I trim down the processing time? Would inserting every xml retrieval into a db make it display faster? Data can range from 1 row, to 300 rows..

halojoy

Im retrieving real time data via xml from another server,
formatting it, sorting it, then displaying it. Its taking ages

The keyword here is ANOTHER SERVER.

As a rule I never include images, pages or files from OTHER Websites.
- if other website goes down, my webpages goes CORRUPT, if they work at all
- if for some reason other server is slow, my pages will be SLOW
- in short, my website is dependent other server is working alright and fast

An example.
When you validate your XHTML 1.0 page at
http://validator.w3.org/
you are told you can add a little picture http://www.w3.org/Icons/valid-xhtml10
to your website

Instead of using this code at my website, I download a COPY of that image and put it at MY Server.
And change code to point to Image at My Server.

  <p>
    <a href="http://validator.w3.org/check?uri=referer"><img
        src="http://www.w3.org/Icons/valid-xhtml10"
        alt="Valid XHTML 1.0 Strict" height="31" width="88" /></a>
  </p>

this way my pages does not depend on other server - too work
and will be faster than downloading stuff, image from Other server

epimeth

that is assuming he has a database on his own server... I'd give it a shot. try sorting in the db and see if that speeds things up...

epimeth

but like halo said, a lot of the slowness may be because of the round trip busride on the information superhighway your little query makes...

yes. I said it. sue me