Re: [SOAP] Generic Database Access

Oh yea, my SOAP server has a feature to populate a child when the child requests, that about 3000 records (for the particular table I'm discussing, there are others). I notices that I couldn't send a response of 3000 records represented in SOAP/XML. Way too much data. What I did was to scale that down and only send 200 at a time, but now the client has to make 15+ requests to my server each time with an offset+=200. It's slow but I can still send all those records over in a reasonable amount of time. Since what I'm doing isn't 100% real-time/live this works, but if I had to real-time I'd force my subscribers to run a PostgreSQL client and let them in that way. /B ----- Original Message ----- From: "Rob Booth" <rbooth@indyme.com> To: <soap@lists.php.net> Sent: Friday, August 01, 2003 15:52 Subject: 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 > > > > -- > PHP Soap Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php