FWD » Core Development » Database

10/22/2016

09:54 PM Feature #1587: implement full support for word indexes

Igor Skornyakov wrote:
> Can an application logic use such dirty reads in any reliable and consistent way? I can har... Eric Faulhaber

10/21/2016

05:17 PM Feature #1587: implement full support for word indexes

Eric Faulhaber wrote:
> * What are the implications for dirty database? Progress does not use an MVCC model, so when... Igor Skornyakov

12:33 PM Feature #1587: implement full support for word indexes

Eric Faulhaber wrote:
> The documentation is clearly a good place to start, but ultimately, we need to confirm any d... Igor Skornyakov

12:29 PM Feature #1587: implement full support for word indexes

Igor Skornyakov wrote:
> Eric Faulhaber wrote:
> > * How and when does Progress update its word break tables? We ne... Eric Faulhaber

12:00 PM Feature #1587: implement full support for word indexes

Regarding the HQL compliance. As a hack it is possible to create auxiliary views for n = 1,..., N which are the "fibe... Igor Skornyakov

11:26 AM Feature #1587: implement full support for word indexes

Eric Faulhaber wrote:
> * How and when does Progress update its word break tables? We need to match this behavior, s... Igor Skornyakov

10:44 AM Feature #1587: implement full support for word indexes

Some other things to consider:
* How and when does Progress update its word break tables? We need to match this beha... Eric Faulhaber

09:55 AM Feature #1587: implement full support for word indexes

We've already made several changes to the HQL->SQL generator in Hibernate. I could envision placing a marker keyword ... Eric Faulhaber

09:37 AM Feature #1587: implement full support for word indexes

Eric Faulhaber wrote:
> You have come up with some good potential solutions to deal with the CONTAINS syntax as SQL,... Igor Skornyakov

09:33 AM Feature #1587: implement full support for word indexes

You have come up with some good potential solutions to deal with the CONTAINS syntax as SQL, but the impedance mismat... Eric Faulhaber

05:03 AM Feature #1587: implement full support for word indexes

The use of @UNION ALL@ can be avoided with use of CNF (Conjunctive Normal Form). For example
@SELECT <fields> FROM t... Igor Skornyakov

10/20/2016

03:38 PM Feature #1587: implement full support for word indexes

I like the directness of this approach and in fact I have been trying to move as much HQL processing to SQL for perfo... Eric Faulhaber

02:40 PM Feature #1587: implement full support for word indexes

Eric Faulhaber wrote:
> Of course, we want as few round trips to the database as possible, ideally only one. Please ... Igor Skornyakov

02:24 PM Feature #1587: implement full support for word indexes

Of course, we want as few round trips to the database as possible, ideally only one. Please provide an example of wha... Eric Faulhaber

01:47 PM Feature #1587: implement full support for word indexes

Regarding the queries with use of a word-break table. In a case of the complex expression in the @CONTAINS@ it can be... Igor Skornyakov

07:28 AM Feature #1587: implement full support for word indexes

Igor Skornyakov wrote:
> Here is the (expanded) summary of the recent e-mail discussion between Greg, Eric, Ovidiu a... Igor Skornyakov

06:30 AM Feature #1587: implement full support for word indexes

Here is the (expanded) summary of the recent e-mail discussion between Greg, Eric, Ovidiu and myself regrading the su... Igor Skornyakov

10/07/2016

08:12 AM Bug #3192: possible optimization when the database server resides on the same box as the P2J server

When the P2J server and database server run on the same UNIX/Linux system, it may be possible to use the JDBC drivers... Greg Shah

08:00 AM Bug #3192 (New): possible optimization when the database server resides on the same box as the P2...

Greg Shah