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

 
 

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

sr #102391: performance boost: mssql

Submitted by:  Sigurd Nes <sigurdne>
Submitted on:  Mon 01 Sep 2003 07:51:38 AM UTC  
 
Category: Feature RequestPriority: 5 - Normal
Severity: 2 - MinorStatus: None
Privacy: PublicAssigned to: None
Open/Closed: OpenOperating System: None

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

Will add this soon

Dave Hall <skwashd>
Project 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>
Project Member

 

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

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

    Do you think this task is very important?
    If so, you can click here to add your encouragement to it.
    This task has 0 encouragements so far.

    Only logged-in users can vote.

     

    Please enter the title of George Orwell's famous dystopian book (it's a date):

     

     

    Follow 2 latest changes.

    Date Changed By Updated Field Previous Value => Replaced By
    Sat 06 Mar 2010 02:14:41 AM UTCskwashdAssigned toskwashd=>None
    Mon 13 Oct 2003 06:02:09 AM UTCskwashdAssigned toNone=>NA

    Back to the top


    Powered by Savane 3.1-cleanup