main logo
Subject: Re: SQL Status? (If you don't mind =)
Author: Ruslan Zasukhin
Posted: 2001/02/28 15:29:00
 
View Entire Thread
New Search


on 28/2/01 19:11, Aaron Bratcher at aaronbratcher AT mac D.O.T com wrote:

> Hi, just wondering how the new SQL parser is coming along. Very anxious to
> start using it =)
>
> If you're tired of people asking and want to keep mum, that's fine too.

Hi Aaron,

just yesterday I have describe status and plans:

> I am working Steve. Only on this task.
>
> Actually this task itself I have done on low level.
> Now I have to redesign middle-level classes and calls.
> Also I have found a lots of not optimized places.
>
> VERY hard, I must to say.
> I also try do changes to be ready for new SQL parser,
> so often I just seat and think.
>
> I really hope to start testing in 2-3 days.

so Aaron, I work right now not on SQL parser itself
but on SQL classes which are built as result of SQL parsing and then execute
it.

>> Hi Ruslan,
>>
>> I know, I know, we meant exactly the same...:-)
>> But, WHEN are going to implement this into the V4MD?
>> Any time soon? Any dates for version 1.9?
>
> at first will be 1.8.8 with significant changes in SQL engine.
> this must give:
>
> a) speed up on some SQLs
> b) ability to search NOT INDEXED fields
> c) ability to reduce selection in AND conditions
> d) this prepare for next improvements in SQL parser.
>
> I hope to get 1.8.8 beta in week
> bugs in 1-2 weeks

1.8.8 must give good speed up for many types of SQL queries.
As you could see Steve see that direct BaseObject API can be about 50-100
times faster of SQL API for simple of specific queries.

I try to implement SQL engine to be smart and recognize this cases to do
work faster without not needed overhead.


> --------------
> 1.8.9 will be short and fast release extending API in some products and
> fixing garbage collection problems for RB and Java.
>
>
> --------------
> Then start for 1.9 with new SQL parser.


--
Best regards,
Ruslan Zasukhin

-------------------------
Paradigma.

e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com

To subscribe to the Valentina mail list
send a letter to valentina-on AT lists D.O.T macserve.net
 
©2001 Ruslan Zasukhin
<-- Prior Message New Search Next Message -->