[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-developers] performance boost: mssql
|
From: |
sigurdne |
|
Subject: |
[Phpgroupware-developers] performance boost: mssql |
|
Date: |
Mon, 1 Sep 2003 09:50:39 +0200 |
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
- [Phpgroupware-developers] performance boost: mssql,
sigurdne <=