RE: [firebird-support] Re: Grouping without sorting alphabetically

2015-02-13 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
Dataset: 1Haemogram Report 1Routine Haemogram 1Haemogram Report 5Diff. Count (Mature Cells) 1Haemogram Report 10 Special Investigations 2Haemogram Report

[firebird-support] Determine total pre-allocated space

2015-02-13 Thread Bryan Cole bryan.c...@teraview.com [firebird-support]
Hi, I need to be able to detect when the total available space for a firebird database is running low. When this happens I need to warn users to purge old data. However, deleting data does not free up disk space. This in itself is fine, but how can I measure the resulting free space in the

[firebird-support] Performance diff between insert...select and for select ... do?

2015-02-13 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Hi, I'm writing a utility that will need to do two things for each record in an external table and for this purpose I use a for select ... do construct in an execute block. I do it this way because external tables can't be indexed and I will scan the entire external table anyway. The two

Re: [firebird-support] Re: Grouping without sorting alphabetically

2015-02-13 Thread Venus Software Operations venussof...@gmail.com [firebird-support]