[Sqlrelay-discussion] large-scale deployment?
Brought to you by:
mused
|
From: John K. <kl...@gm...> - 2008-01-30 14:15:09
|
Hi, I browsed through the list archive, but didn't see anything on this topic... I'm considering SQL Relay for a particular need we have, for which it seems amazingly, wonderfully suited. However, the environment in which I'm working is rather large... We've got thousands of users spread all over the global, over an intranet/WAN. They run perl scripts that hit a database, where the separation between the clients and the servers can be on the order of thousands of miles (California to India, in some cases). These scripts get run, literally, 250,000+ times a day. And at that, our database can't handle the concurrency that results from the arbitrary, ad-hoc execution of these scripts, from anywhere and everywhere. We'd like to employ some connection pooling and throttling, to even things out. (No, I didn't design the system. :-)) Anyway, before I get too excited about SQL Relay, can anyone share a success story, where SQL Relay was used in an environment this large? Thanks in advance... |