[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-tracker] [support #102391] performance boost: mssql
From: |
nobody |
Subject: |
[Phpgroupware-tracker] [support #102391] performance boost: mssql |
Date: |
Mon, 13 Oct 2003 02:02:10 -0400 |
User-agent: |
Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.3.1) Gecko/20030618 Debian/1.3.1-3 |
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/
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-tracker] [support #102391] performance boost: mssql,
nobody <=