Are there any special transactional considerations?

Alan
-----Original Message-----
From: erg_sg [mailto:erg_sg@...]
Sent: Wednesday, 23 October 2002 19:09
To: ib-support@yahoogroups.com
Subject: [ib-support] Re: Database Crash


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



Yahoo! Groups Sponsor
ADVERTISEMENT




To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.



[Non-text portions of this message have been removed]