Can I use multiple API's to write to the same SQL Server database simultaneously?
Posted on 2008-11-06
I am a bookseller and I use an API to gather data on books (title, price, etc.) from Half.com, a division of EBay. Although EBay has given me permission to make 1.5 million requests per day, the API is only capable of processing 15-20,000 requests a day. I have talked to EBay tech support and they are telling me the call I am using is the only one available for my purposes and there really is no way to increase the speed. However, they did tell me I can run multiple instances of the same API providing my "database and hardware can support it". Right now the API will get data from Half.com one book at a time and write the data to a SQL Server database. My question is would I be able to run multiple intances and write to the same database simultaneously? If not, would I be able to write to multiple databases simultaneously and then combine the data later?