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

[Sigurd Nes]

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




/**************************************************************************/
[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:  None
Assigned to:  skwashd
Originator Email:  
Status:  Open


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)





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/