Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread Gopala Krishna Gundeboyina
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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread liviuslivius
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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread Gopala Krishna Gundeboyina
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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread liviuslivius
>>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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread liviuslivius
>> 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 -

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread Gopala Krishna Gundeboyina
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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread Dimitry Sibiryakov
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

Re: [Firebird-devel] Odp: SQL Hint

2013-01-26 Thread liviuslivius
> 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. >>>-- >