mainphpGroupWare - Support: sr #102391, performance boost: mssql

 
 

You are not allowed to post comments on this tracker with your current authentication level.

sr #102391: performance boost: mssql

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Mon 01 Sep 2003 07:51:38 AM UTC
   
 
Category:  Feature Request Priority:  5 - Normal
Severity:  2 - Minor Status:  None
Privacy:  Public Assigned to:  None
Open/Closed:  Open Operating System:  None

Mon 13 Oct 2003 06:02:09 AM UTC, comment #1: 


Will add this soon

Dave Hall <skwashd>
Group administrator
Mon 01 Sep 2003 07:51:38 AM UTC, original submission:  


add to limit_query in class.db_mssql.inc.php:

$Query_String = str_replace('SELECT ', 'SELECT TOP ',
$Query_String);
$Query_String = str_replace('SELECT TOP DISTINCT',
'SELECT DISTINCT TOP ', $Query_String);
$Query_String = str_replace('TOP ', 'TOP ' . ($offset +
$num_rows ), $Query_String);

Sigurd Nes <sigurdne>
Group Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by skwashd (Updated the item)
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

     

    Follow 2 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2010-03-06 skwashd Assigned toskwashd None
    2003-10-13 skwashd Assigned toNone None

    Back to the top

    Powered by Savane 3.14-3b9d.
    Corresponding source code