[Phpgroupware-tracker] [patch #3201] speed up results from mssql

[Dave Hall]

This mail is an automated notification from the patch tracker
 of the project: phpGroupWare.

/**************************************************************************/
[patch #3201] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Sun 10/31/2004 at 14:09 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
          Resolution | None                      | Applied
              Status | Open                      | Closed


------------------ Additional Follow-up Comments ----------------------------
Added to proposed 18 branch






/**************************************************************************/
[patch #3201] Full Item Snapshot:

URL: <http://savannah.gnu.org/patch/?func=detailitem&item_id=3201>
Project: phpGroupWare
Submitted by: Sigurd Nes
On: Sun 07/11/2004 at 11:48

Category:  API -  phpGWapi
Priority:  5 - Normal
Resolution:  Applied
Privacy:  Public
Assigned to:  skwashd
Originator Email:  
Status:  Closed


Summary:  speed up results from mssql

Original Submission:  How about limiting the result returned from mssql by 
using TOP. (This way the result is maxmatchs (15) instead of 22000 for 
workorders in "property" in my case)

Follow-up Comments
------------------


-------------------------------------------------------
Date: Sun 10/31/2004 at 14:09       By: Dave Hall <skwashd>
Added to proposed 18 branch






File Attachments
-------------------

-------------------------------------------------------
Date: Sun 07/11/2004 at 11:48  Name: mssql.diff  Size: 698B   By: sigurdne
limit query by using 'TOP' for mssql
http://savannah.gnu.org/patch/download.php?item_id=3201&amp;item_file_id=3451






For detailed info, follow this link:
<http://savannah.gnu.org/patch/?func=detailitem&item_id=3201>

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