Here is my problem. I have two websites, website A and website B. Website A uses local database and website B is offering an API. I have to merge records from website A and B (API).
For example, a category (id = 10) on website A is merged with a category on website B (id = 20),
Now I need to merge records from local database and API. I can merge two arrays, but I need to sort records as well.
On website A I use queries to get records and from website B I use soap API.
What is the best way I can sort records by publish_date or title? keeping in mind there can be thousands of records from each database.
Any help would be appreciated :)