Re: [SOAP] Generic Database Access

"David Busby" <busby@pnts.com> wrote in message news:024a01c35877$2eb4a8d0$1100000a@busbydev... > Rob, > I don't have a solution, just my story. I had a similar problem, I > needed to send data across the country from my database here in Seattle > (PostgreSQL) to some folks in St. Paul. They used BEA web logics or > something, I'm all OpenSource. So the communication is done with SOAP. > They send a small SOAP query and I send results back. On some of the > queries I send back over 200 records! As you stated adding XML/SOAP > overhead for each field is a lot. Since I didn't see any solution (the same > you seek) I just decided to brute force it to go and said "F it, I guess > I'll have to have that overhead". > > What about the performance? > > The sytems can send about 63 records (rows in the DB) per second, really > slow compared to direct DB access. However, the average number of records I > need to send in any given second is only four. So it works for me. > Thanks David, One question have you run into any issues with very large datasets? I have another Service that is choking on a large amount of data and I haven't been able to figure out why. Rob