... when I do accounting systems, one of the first things I do is design around a period (fiscal or calendar year). This makes for totaling much faster than ...
... For developing it's rather a matter of searching around...for example, the TechInfo section at the IBObjects website has a number of papers that address...
Alexandre, thanks for the response. I am thinking we may need to quickly access random data, so a hash indexing scheme would be nice. The B*Tree also gives us...
Two possible approaches to calculating the running balance per record that you could look at are: a) use a 'selectable stored procedure' (& calculate the...
... There is no hash index in FB, but I think you should first try FB to see if it performs good enough for you. FB uses a two-phase index scan, first it reads...
Hi guys I've spent hours now looking for a way to do this... There are scripts for Linux/Unix that come with Firebird for adding Aliases to the aliases.conf...
... There is no such tool in FB. Write a simple application that the user would select the database file trough a open dialog and add it to the aliases.conf. ...
... Yes and no: Parallel execution paths require that the one process (and multiple execution threads) are present on the one physical processor. So even if ...
Nigel Weeks
nweeks@...
Oct 10, 2008 3:35 am
97510
... And even the file system cache would play nice, when using CS the "best bet" is to leave the cache size at the default level (75 pages) and let the file...
... From an operating system's point of view, there's no different between a processor and core -- a "dual-core" processor is basically two physical processors...
Dean Harding
dean.harding@...
Oct 10, 2008 4:00 am
97512
... Someone will correct me if I am wrong... but AFAIR SS has multiples threads, but the syncronization logic is not good enough and serializes the threads...
In a similar situation I am using a selectable stored procedure, which calculates the current balance in an output variable. Emil ... Firebird ... movements ...
... the transaction doesn't finish for any reason then the work done by triggers and SPs remains unfinished. The work is committed if the transaction commits...
First of all: Thank you guys for all the inputs!! So, I see that nobody uses a separate table mantained with triggers to do that, which make think I won't have...
... Yes. A transaction is a wrapper around an atomic unit of work. Of course multiple calls to the database can (and should!) occur within a single transaction...
... a view won't give you running balances, only ending balances I can only do running balances on the client and it requires all records being brought over...
... Certainly within a transaction that your application has complete control of. Since you are using IBO, you can (and should) do that *as a basic*....
I expect the answer to be NO, but I want to try anyway (Firebird has its surprises from time to time): Is there a way to insert Blob data via a script command....
... No - Firebird supports only b*tree indexes. For more information try here: http://www.ibphoenix.com/main.nfs?page=ibp_expert1 ... I'm not quite sure what...
Some of the columns in one of my tables contain mainly nulls, others contain very few. I am trying to improve performance of a procedure which updates many ...
Hi Sergio, sorry for answering late, but I didn't have any time to try out my idea before now... Since I'm normally using Firebird 1.5, I've no experience in...
... Actually yes. Firebird will automatically cast a varchar to a blob, so just write your insert statement as if it were a varchar field. However there are...
