[Sqlrelay-discussion] Can sqlrelay handle 1000 tx/s against oracle?

[simon m. <sm...@mi...>]

Hi List,

I have a customer who has 150 branches, each branch has about 10 POS
(Point Of Sales) terminals (PC + Software). I wrote the system that sits
in between the POS and all the back end servers (JDE OneWorld, Credit
System, external information providers, etc.). Both OneWorld and the
Credit System use oracle 9i as a data store, the credit system is
actually written in PL/SQL. The oracle database engine is running on an
RS6000, 8 processor system using AIX 5.2.

At peek times we are pushing about 1000 transactions per second through
the database (every POS service requires about 20 transactions, of which
about 10% go to oracle). On average a transaction will take about 500ms
to complete, except credit payments which touch about 30 tables and take
about 1500ms under normal circumstances and up to 5s every 10th day of
the month (by default the credit payments fall on the 5th, 15th, 25th
day of the month).

To handle this transaction volume I wrote my own connection pooling
software. It has it's problems (like all software) but it's stable
(haven't had to touch it in the last 2 years). Unfortunately it only
allows me to call stored procedures or functions, and I now have a
requirement to perform queries directly on the underlying tables.

For a while I have been contemplating using sqlrelay with this
customer's application, having used it successfully elsewhere, but I
don't know whether it'll take this kind of punishment.

Can anyone shed any light on this? Anyone had any similar requirements?

TIA

--=20
    __ _   Debian GNU User   Simon Martin
   / /(_)_ __  _   ___  __   Project Manager
  / / | | '_ \| | | \ \/ /   Milliways=20
 / /__| | | | | |_| |>  <    mailto: sm...@mi...
 \____/_|_| |_|\__,_/_/\_\   ICQ: 81183862