Importing slow data from another site.

Hi,

I have two sites under my control.

One site is the main site and the other one is a database catalogue that provides data to external sources via xml.

I want to pull data from the xml to the main site. However the database catalogue is really slow.

When I pull this data back to the main site doesn't display the site until all the date is loaded. Effectively slowing the main site to the speed of the second site.

Is there anyway to display the main site as normal, and display the imported date when it is compiled?

e.g. the main site loads super fast with a please wait... type thing in one small corner, this is then replaced with the data when it is ready?

Hopefully that makes sense, any help would be grateful.

 

The better solution is to optimize your application and use indexes in database.

 

Why not using a batch/cron script to generate the content in cached files on the main site?

 

Thanks for your replies.

Unfortunately that is not an option.

The application will always be slow, we are talking multi-million records that is constantly updated (and unfortunately it not something that I have written so I cannot really modify it) and it has to be live data.

 

Solved, used Ajax in the end. Works really well!