Hi,



Please find the current database activities





INSERT INTO MON$DATABASE (MON$DATABASE_NAME, MON$PAGE_SIZE,
MON$ODS_MAJOR, MON$ODS_MINOR, MON$OLDEST_TRANSACTION, MON$OLDEST_ACTIVE,
MON$OLDEST_SNAPSHOT, MON$NEXT_TRANSACTION, MON$PAGE_BUFFERS,
MON$SQL_DIALECT, MON$SHUTDOWN_MODE, MON$SWEEP_INTERVAL, MON$READ_ONLY,
MON$FORCED_WRITES, MON$RESERVE_SPACE, MON$CREATION_DATE, MON$PAGES,
MON$STAT_ID, MON$BACKUP_STATE) VALUES
('D:\RITEQFIREBIRD\RELEASE2\TIMETEQ-FIREBIRD-TEST-RELEASE2.FDB', '4096',
'11', '2', '3025453', '3025454', '3025454', '3025454', '2048', '3', '0',
'20000', '0', '1', '1', '29.10.2011, 14:01:34.696', '6847', '1', '0');





Thanks

Mahesh



________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Thomas
Steinmaurer
Sent: Monday, November 21, 2011 12:24 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] application got slow down

> I am using firebird 2.5.1 from the .Net application by using the .net
> provider 2.5.2. while using application, it is slowing down after
> inserting around 200 record.

> Could you please let me know where the problem, same application is
> running fine in SQL server 2008?
>
> I need some help to diagnosis the problem.

A general first database performance sanity check is to run:

gstat- h

when things are slow to see, if OIT/OAT are way behind. As you are using

2.5, use the MON$ tables for getting a snapshot of the current database
activities or the new Trace API to get a continous stream of executed
events. With the Trace API you also get information on execution time,
execution plan etc ...

--
With regards,
Thomas Steinmaurer

* Firebird Foundation Committee Member
http://www.firebirdsql.org/en/firebird-foundation/

* Upscene Productions - Database Tools for Developers
http://www.upscene.com/

* My Blog
http://blog.upscene.com/thomas/index.php





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