Running ASP in distributed database environment
i need to design an employee leave application system in asp with distributed access db at the backend (meaning that i will be using one application and two dbs at two distinct locations-say A and B). Leave applications of location B employees needs to be displayed and acted upon at location A .
what i m doing is I m using a single asp file with two connection strings (one for each database) to fetch and display data from two dbs. The problem with this is when i execute my asp file, the page loading time is either too slow (becoz it needs to fetch data from two distinct db) or it drops frequently. i have increased the session time out but no results this time even. Can anyone suggest a better way of doing it?
Any help will be highly appreciated.
P.S. I can't go for a centralized database. I have to do it on distributed databases.