Hi Karol,
No problem. This application can handle up to 300k records/second which is
the reason we couldn't use Firebird. In fact for your information we
replaced our file based storage to Cassandra now. But Firebird is still
there as a SQL interface :)
Thanks,
Gopala
On Sun, Jan 27, 2013 at 12
On Sat, Jan 26, 2013 at 9:25 PM, wrote:
You can store config info in db not in xml – what problem?
You can do import xml into db
>>Well it is correct for an application built over a RDBMS database as a data
>>layer.
>>My application doesn't depend on any database. It is a real-time data ca
On Sat, Jan 26, 2013 at 9:25 PM, wrote:
> You can store config info in db not in xml – what problem?
> You can do import xml into db
>
Well it is correct for an application built over a RDBMS database as a data
layer.
My application doesn't depend on any database. It is a real-time data
capture
>>One example is that we have bar generation queries (N minute intervals). The
>>bar generation logic is complex and depends on numerous domain rules and
>>filter conditions. These rules are defined in xml format and carries a name.
>>While making >>queries, user can specify to generate bar data
>> Not all. Only about those which are in Firebird database. TS plugin
>> works with external
>>database.
>>>--
>> WBR, SD.
And external database know about own indexes - i am right?
Regards,
Karol Bieniaszewski
-
On Sat, Jan 26, 2013 at 2:05 PM, wrote:
> Give me one real example wchich can not be acomplished with db but can be
> with this "Hint" feature
>
One example is that we have bar generation queries (N minute intervals).
The bar generation logic is complex and depends on numerous domain rules
and f
26.01.2013 9:35, [email protected] wrote:
> FB know about all indexes.
Not all. Only about those which are in Firebird database. TS plugin works
with external
database.
--
WBR, SD.
--
Master Visual Stu
> what your “hint” can do what you can not do with normal selects, execute
> block in normal
> database?
>>> AFAIU, he can pass filter condition to his external data access engine
>>> and thus limit
transferred data amount, use indices about which Firebird has no idea,
etc.
>>>--
>
25.01.2013 17:46, [email protected] wrote:
> what your “hint” can do what you can not do with normal selects, execute
> block in normal
> database?
AFAIU, he can pass filter condition to his external data access engine and
thus limit
transferred data amount, use indices about which
>>Thanks a lot Adriano.
>>This will definitely fit in my case very well. Let me take a look into this.
>>@Alex: Sorry that was v2.1.3 :)
>>Thanks,
>>Gopala
Hi,
i still do not see reason why you doing this in “wrong” direction
why you do not use execute statement
what your “hint” can do what
Thanks a lot Adriano.
This will definitely fit in my case very well. Let me take a look into this.
@Alex: Sorry that was v2.1.3 :)
Thanks,
Gopala
On Thu, Jan 24, 2013 at 1:50 PM, Adriano dos Santos Fernandes <
[email protected]> wrote:
> On 24/01/2013 11:40, Gopala Krishna Gundeboyina wrote
On 24/01/2013 11:40, Gopala Krishna Gundeboyina wrote:
> Hi Adriano,
>
> I have this implemented as an UDF and currently using it as
> workaround. My queries look like this:
>
> * select * from VISITLOG where HINTUDF('USERCATEGORY=''cat1''') =1.
>
> I am parsing the blr to extract this informatio
Hi Adriano,
I have this implemented as an UDF and currently using it as workaround. My
queries look like this:
- select * from VISITLOG where HINTUDF('USERCATEGORY=''cat1''') =1.
I am parsing the blr to extract this information and also optmized it to
execute the HINTUDF udf only once instead
On 01/24/13 16:14, Gopala Krishna Gundeboyina wrote:
> @Alex: I embedded standalone Firebird Server (not embedded Firebird server)
It's just different names for same thing. Be sure - each embedded server
can query outer world.
> in to my application as a Dll. So Firebird Server works as a standa
On 24/01/2013 10:14, Gopala Krishna Gundeboyina wrote:
> @Alex: I embedded standalone Firebird Server (not embedded Firebird
> server) in to my application as a Dll. So Firebird Server works as a
> standalone most of the time but only for configured external tables it
> uses my library for data ret
@Alex: I embedded standalone Firebird Server (not embedded Firebird server)
in to my application as a Dll. So Firebird Server works as a standalone
most of the time but only for configured external tables it uses my library
for data retrieval.
I have this done on Firebird Server v2.3 at the time E
On 01/24/13 12:53, Dmitry Yemanov wrote:
> 24.01.2013 12:44, Alex Peshkoff wrote:
>
>> You did not understand Karol's answer. It does not matter how is
>> organized your application - as soon as firebird engine starting with
>> v.2.5 is embedded into it you can use execute statement to access
>> ex
24.01.2013 12:44, Alex Peshkoff wrote:
> You did not understand Karol's answer. It does not matter how is
> organized your application - as soon as firebird engine starting with
> v.2.5 is embedded into it you can use execute statement to access
> external datasources.
But not data sources that a
On 01/24/13 11:40, Gopala Krishna Gundeboyina wrote:
> Hi Karol,
>
> Thanks for the reply.
>
> My application is not a relational database but a library and hence I
> cannot use execute statement.
>
> This application stores data in binary format on disk with a complex
> business logic applied and
Hi Karol,
Thanks for the reply.
My application is not a relational database but a library and hence I
cannot use execute statement.
This application stores data in binary format on disk with a complex
business logic applied and has c++ apis to access data. I embedded the
Firebird Server (v2.5) w
HI,
first of all wrong group this is not support list.
But you doing somethink what is supported by execute statement, and you do mot
need to modify external table intf. Execute statement in Fb2.5 can run query
against external database
Regards,
Karol Bieniaszewski
- Reply message -
Od
21 matches
Mail list logo
