Re: [firebird-support] Re: URGENT - Database performance is very slow
07.06.2018 11:14, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Attached snap, since it is not displaying in message body. It is useless: no attachments in this list allowed. You must cooperate with DBA and system administrator to analyze performance problems. It is not so trivial task to be done via support mail-list. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] in new API
Hello, in the new API, how to find the transaction id (= current_transaction) and connection (= current_connection)? thank you in advance -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
Re: [firebird-support] Getting Group By subtracting total for every record in the group
07.06.2018 13:43, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Partition and Order BY is not useful to get the expected result as discussed > in previous mail. On contrary, partition AND order by is exactly what you need. Read documentation that Vlad suggested. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: in new API
> in the new API, how to find the transaction id (= current_transaction) > and connection (= current_connection)? Almost the same way as with ISC API: use ITransaction::getInfo() and IAttachment::getInfo() Regards, Vlad http://tetrasys.fi
[firebird-support] Re: URGENT - Database performance is very slow
Attached snap, since it is not displaying in message body. On Thursday, 7 June, 2018, 2:42:29 PM IST, Vishal Tiwari wrote: We also tried to do sweep but still there is no improvement. On Thursday, 7 June, 2018, 1:50:12 PM IST, Vishal Tiwari wrote: Hi All, It's urgent... We are facing a database performance issue. Currently, we are using firebird version 2.5.2 ODS 11.2. If we try to run a simple SQL i.e. Select * from using FlameRobin, it is taking time and next time the time span increases. Same happens from all of our applications side as well. We have Desktop applications build using Delphi. Kindly refer to below snap. Thanks In Advance. With Best Regards. Vishal [Non-text portions of this message have been removed]
Re: [firebird-support] URGENT - Database performance is very slow
Vishal Tiwari wrote: > It's urgent... > We are facing a database performance issue. Currently, we are using firebird > version 2.5.2 ODS 11.2. > If we try to run a simple SQL i.e. Select * from using > FlameRobin, it is taking time and next time the time span increases. > Same happens from all of our applications side as well. We have > Desktop applications build using Delphi. > Kindly refer to below snap. It's no good trying to send screenshots or any kind of attachments to the list. They are dropped automatically. First, v.2.5.2 is buggy and very old. Replace it with v.2.5.8. You don't need any migration for this; just keep copies of your security database, firebird.conf and aliases.conf so you can copy them back into your new installation. Then, run gstat -h on the database and copy the output into your next post. (Rt-click on the title bar of the command window, select Edit then Select All. Hit enter to copy, Ctrl-V to paste into your email.) A typical reason for Delphi applications to exhibit progressive slowdowns is poor transaction management, specifically those written with long-running read-write transactions that never get committed. Garbage builds up and builds up in the database just from everyday usage, in the form of thousands of old record versions that can't be flagged "uninteresting" because of all those uncommitted transactions. You observe the slowdown in FlameRobin, isql, et al., because all that garbage is trapped in the database. You can improve that permanently by rewriting the offending application code. In the meantime, do regular sweeps or gbak backups in (gfix) shut -single mode to clear out the trash. If you are already doing that, then you probably need to do it more often. So first things first - update Firebird and let's look at those transaction statistics from the database header. HB --- This email has been checked for viruses by AVG. https://www.avg.com
[firebird-support] Re: URGENT - Database performance is very slow
We also tried to do sweep but still there is no improvement. On Thursday, 7 June, 2018, 1:50:12 PM IST, Vishal Tiwari wrote: Hi All, It's urgent... We are facing a database performance issue. Currently, we are using firebird version 2.5.2 ODS 11.2. If we try to run a simple SQL i.e. Select * from using FlameRobin, it is taking time and next time the time span increases. Same happens from all of our applications side as well. We have Desktop applications build using Delphi. Kindly refer to below snap. Thanks In Advance. With Best Regards. Vishal [Non-text portions of this message have been removed]