Hi, I would like to ask group members about jBASE performance in relation to distributed files.
We have noticed that SELECTs with criteria on distributed may be 4 times slower than on regular files. I think that reason is quite clear: jBASE is querying each partfile and then reading record from it to qualify it or throw it away from select list. Reading of the record is however not clever process. Distributed routine is run unnecessary for each record, which causes a lot of overhead. Does jBASE need to confirm that key taken from part file #1 is still in part file #1? ;) We have raised it as performance bug. I would expect that jBASE reads part files one by one and does not need to invoke distribution routine. What do you think? Our suggestion relates also to part files scanning - it could be done in separate processes too (just to speed up selection process). PS. I know that it is not clever to ask quries against distributed files, but why not to optimize jBASE? :) Kind regards Pawel ---------------------------------------------------- Nie czekaj na LAST minute! Zaplanuj teraz swoje wakacje. To się opłaca! Zniżki nawet do 30%. Sprawdź: http://klik.wp.pl/?adr=http%3A%2F%2Fcorto.www.wp.pl%2Fas%2Fznizki30procent.html&sid=665 --~--~---------~--~----~------------~-------~--~----~ Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en -~----------~----~----~----~------~----~------~--~---
