[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Can I use multiple API's to write to the same SQL Server database simultaneously?

Posted on 2008-11-06
2
Medium Priority
?
219 Views
Last Modified: 2010-03-19
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?
0
Comment
Question by:bpfsr
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 22900666
> and write to the same database simultaneously?
yes, that is perfectly possible.
0
 

Author Comment

by:bpfsr
ID: 22900982
Is there anything special I need to do or do I just run the API's? One of the reason I ask is because when if I start the API and I have SQL Server Management Studio open, the API won't run and I get an error message along the lines of "database is not available". That is what made me think maybe you can only have one "stream" open to a database at a time...
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question