[firebird-support] Materialized views

2014-06-07 Thread kokok_ko...@yahoo.es [firebird-support]
Is there a plan to add materialized views in version 3.0 If not, which would be the workaround to do it in Firebird 2.5 without using triggers? Basically I would need to update the materialized views once each 2-3 days, so probably using a stored procedure would be enough. I thought using a

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-07 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 06.06.2014 15:11, Mike Ro miker...@gmail.com [firebird-support] wrote: Frank, thank you for taking the time to do this. It confirms that there is definitely something wrong with my setup (are you using Firebird version 2.5.2?). No, its LI-T3.0.0.31151 Firebird 3.0 Alpha 2, but that

Re: [firebird-support] Materialized views

2014-06-07 Thread Thomas Beckmann thomas.beckm...@assfinet.de [firebird-support]
Hi, if you can commit yourself in maintaining one or the other rule in writing the body of the viesws, it should not bee too complicate to find out what tables and fields you are refering and to query system tables for data types of you materialized views... Thomas Am 07.06.2014 14:36, schrieb

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-07 Thread Mike Ro miker...@gmail.com [firebird-support]
On 07/06/14 14:42, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: This is probably the cause of the exception: declare external function f_insertblob cstring (20), blob returns int by value entry_point 'insertblob' module_name 'test_udf.so'; should be