[Phpgroupware-tracker] [support #102391] performance boost: mssql

[nobody]

Support Request #102391, was updated on Mon 09/01/03 at 17:51
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102391&group_id=509

Category: Feature Request
Status: Open
Priority: 5
Summary: performance boost: mssql

By: skwashd
Date: Mon 10/13/03 at 16:02
Logged In: YES 
user_id=2480
Browser: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3.1) Gecko/20030618 
Debian/1.3.1-3

Will add this soon

----------------------------------------------------------------------

By: sigurdne
Date: Mon 09/01/03 at 17:51
Logged In: YES 
user_id=5071
Browser: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.5a) 
Gecko/20030728 Mozilla Firebird/0.6.1

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);



----------------------------------------------------------------------
You can respond by visiting: 
http://savannah.gnu.org/support/?func=detailsupport&support_id=102391&group_id=509

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/