Alan,

There are some stored procedures and triggers used. Out of these
there is one trigger which posts events (POST EVENT calls) for
selected device events inserted into the database. This could cause a
lot of events being fired from the database. Other stored procedures
and triggers are passively used to indicate processes to delete the
data from the tables.

All database traffic come through one multi-threaded client to which
the devices connect. The client inserts the data into the database. A
GUI is used to display the status of the device by reading the
database tables at regular intervals. The GUI updates some
information about the devices based on the events posted from the
database (as mentioned previously... using the trigger explained
above)

Hope this information helps...
Thanks
--Ergsg

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> Can I deduce that approx 450 devices make approx 450 inserts each
per day?
> Can I deduce that 200,000 inserts per day, maybe thru a peak 4 hour
period =
> 830 inserts per hour / 14 per sec?
>
> I'm not about to offer a solution - just want to put some
perspective on it.
>
> This doesn't seem a lot of traffic. I wouldn't, at first, be
jumping on that
> as the cause.
>
> Can you tell us more about the client? Perhaps something about
triggers and
> stored procedures under this traffic?
>
> Alan