Re: [firebird-support] What makes a database file size so big?

On 29/03/16 11:44, Małgorzata Barchańska go...@fastdata.com.pl [firebird-support] wrote: > I'm very curious - so what makes our database file so big? Sum of clear > metadata > and raw data is about 2,4GB, and what with other 12GB? Is anything we > can do to shrink our big database file (drop

Re: [firebird-support] What makes a database file size so big?

Hi, download HQbird Standard trial (http://ib-aid.com/en/hqbird/) and analyze your database statistics with Database Analyst and database file DBInfo. Database Analyst will give you an exact information of tables and indices sizes tab Tables -> sort on Size), their fragmentation due to

[firebird-support] What makes a database file size so big?

Hi, I use firebird 2.5 classic server on windows operating system. Because our database file is quite big (18GB) and it starts to cause (because of its size) some maintenance inconvenience we decided to try to shrink it. After checking database statistics we deleted "useless" records in tables

Re: [firebird-support] How to add previous column value to current value?

>I need something like this > >Name Date Days betwen Previous date >-- >Name1 date10 >Name2 date2date2-date1

Re: [firebird-support] Listing Table of Database in Order of Dependency

On Mon, Mar 28, 2016 at 11:21 PM, setysvar setys...@gmail.com [firebird-support] wrote: > > > >Hi, > > Hi Rajiv! > > >How can i list tables of a database in order of dependency ie > > > >TABLE_1 (no foreign key references) > >TABLE_2 (foreign key references, if

RE: [firebird-support] How to add previous column value to current value?

let's assume that I have 2.5.3 Pozdrawiam Piotr Olszewski -Original Message- From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Tuesday, March 29, 2016 11:45 AM To: firebird-support@yahoogroups.com Subject: Re: [firebird-support] How to add previous

Re: [firebird-support] How to add previous column value to current value?

29.03.2016 11:40, 'Piotr Olszewski' piotr.olszew...@eskrzynka.pl [firebird-support] wrote: > I need to get a date difference (days between) between rows. With Firebird 3.0 you can use window function LAG. -- WBR, SD.

[firebird-support] How to add previous column value to current value?

Hi I need to get a date difference (days between) between rows. Let say i have: Name Date --- Name1 date1 Name2 date2 Name3 date3 Order by date I need something like this Name

Re: [firebird-support] Firebird database keeps randomly locking up.

On 24.03.2016 12:36, Richard Cooke rich...@alcoeng.co.uk [firebird-support] wrote: > > > > I have a problem with a Firebird database randomly locking up completely > for a period of time sometimes only a 30 seconds, sometimes 10 or 15 > minutes. I would suspect either a virus scanner or the