joins are slow ?

[Ruslan Zasukhin]

On 9/25/04 4:23 PM, "olivier" <vidal_olivier at yahoo.fr> wrote:

>> Please tell by STEPS this.
>> I want to repeat.
> 
> ok.
> 
> I opened the small program " two tables " which was in the folder
> Valentina_RB \ examples \ (3) two tables \ .
> 
> The program did not run because there were methods " #pragma
> arrayBoundsChecking " which do not exist any more in RB 5.5.
> I got rid of to them.
> I set cache to 20 Mo (in TestApplication Class, open event :  "Err =
> ValentinaInit(20 * 1024 *1024, "", "" )"
> I verified that person_ptr and byte_fld were indexed.
> 
> The program run.
> I went to the "test" menu and I clicked twice on "add 100K+400K
> records". 200 000 recordings were thus create in the db.
> 
> Then I have clicked on "scroll_w".
> The window-query appears.
> Query "SELECT * FROM person,task WHERE byte_fld < 10 ".
> I clicked on " do it! ".
> The results appear in the window after 24 seconds on my old powerbook
> (400Mhz, 384 Mo Ram, HD 4200 trs/mn).
> (18 seconds if I entered the same request in viSQL)


I have run example from my DUAL G4/867

I get 6-7 seconds.

Well, probably query really hard.

And I believe that any other db you can try will work much slower.


Of course thank you for point.
We will need think more if this can be done faster


-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------