RE: [firebird-support] Firebird database executing DML queries very slowly.
Hi , This issue was replicated only on client end while I copied the DB on our end it was working with any slowness. I took the remote of client DB , performed validation check on DB & backup - restore operation on DB. After doing this its working normally now. Thanks for help. :) From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Tuesday, January 29, 2019 17:21 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly. Hi Is this from problematic time with connected clients? If yes than i do no see problems. You must provide more details about issue. What exact comand is slow? What are the query plan and query sats? Did you tested HDD isues? … Regards, Karol Bieniaszewski
RE: [firebird-support] Firebird database executing DML queries very slowly.
Ran the command and got the header information from the client. Below is database header page information of the affected database : Flags 0 Checksum 12345 Generation 9101445 Page size 4096 ODS version 11.2 Oldest transaction 8991282 Oldest active 9100701 Oldest snapshot 9100701 Next transaction 9100702 Bumped transaction 1 Sequence number 0 Next attachment ID24698 Implementation ID 26 Shadow count 0 Page buffers 0 Next header page 0 Database dialect 3 Attributes force write Variable header data: Sweep interval:2 *END* The difference between the oldest transaction and newest transaction is large. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Friday, January 25, 2019 20:32 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly. Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski
RE: [firebird-support] Firebird database executing DML queries very slowly.
Thanks, I will try this command on customer end will upload the results. From: firebird-support@yahoogroups.com [mailto:firebird-supp...@yahoogroups..com] Sent: Friday, January 25, 2019 20:32 To: firebird-support@yahoogroups.com Subject: ODP: [firebird-support] Firebird database executing DML queries very slowly. Hi. When you gain slowdows Run gstat -h and put here results. Problem probably is because of some long running transaction. Regards, Karol Bieniaszewski