60,000+ Records/Better Approach

J

Jen

I have a web service that used to deliver around 1000-2000 results when called. Requirements have changed and now the results will contain 60,000 - 100,000 records from an Oracle database. I suspect web service may no longer be the best option. What are some other ideas for delivering the data for use in remote web applications? FTP???
 
J

Joe Duffy

There's nothing inherent in web services which makes the serialization and
transfer of 60-100k records impossible, but certainly within some contexts
it just won't work. Certainly if bandwidth and transfer time are at a
premium, for instance, XML might be bloating your payload meaning you might
be better off with a binary serialization format.

However, it all comes back to the context within which your solution is
required to function. Is this a transactional-based application?
Batch/schedule? Are you working within limited time or data transfer
constraints? How large are your "records"?

Answering these types of questions might help to identify better solutions.

<joe/>

Jen said:
I have a web service that used to deliver around 1000-2000 results when
called. Requirements have changed and now the results will contain 60,000 -
100,000 records from an Oracle database. I suspect web service may no
longer be the best option. What are some other ideas for delivering the
data for use in remote web applications? FTP???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,995
Messages
2,570,230
Members
46,819
Latest member
masterdaster

Latest Threads

Top