View Issue Details

IDProjectCategoryView StatusLast Update
0000685JEDI VCSServerpublic2005-06-13 16:41
ReporterdorsAssigned ToTHuber 
PrioritynoneSeveritytweakReproducibilityalways
Status closedResolutionfixed 
Product Version 
Target VersionFixed in Version2.40 Stable (Server) 
Summary0000685: Speedup GET_SHARED_MODULES
DescriptionSvrOBJModules.pas

procedure TServerObjectGET_SHARED_MODULES.Execute;

        SQL.Add('FROM pjmodule');
        SQL.Add('GROUP BY moduleid');
        {$IFDEF ORACLESRV}
        SQL.Add('having count(*) > 1');
        {$ENDIF}


Before: >1000 Ticks
Now: 200 Ticks
Additional InformationThis probably not only works for the Oracle server, but for others as well. Question is: which one? Comments are welcome!
TagsNo tags attached.
Fix in JVCS version
Releasedocumentation

Relationships

child of 0002361 closedTHuber Releaseinfo: 2.40 server issues 

Activities

THuber

2003-03-22 03:32

developer   ~0001841

DBISAM 3.21 *error*:
is working when changed to
'having count(moduleid) > 1'
============================
Both are working with
Firebird 1.0x, Firebird 1.5b4
=============================

THuber

2003-04-04 14:48

developer   ~0001915

Done for all dbms ports excluding FF.
Should be tested by dbms port maintainers.

Issue History

Date Modified Username Field Change
2005-01-15 05:45 THuber Relationship added child of 0002361
2005-06-13 16:41 THuber Status resolved => closed
2005-06-13 16:41 THuber Fixed in Version => 2.40 Stable (Server)