patchphpGroupWare - Patches: patch #3201, speed up results from mssql

 
 

You are not allowed to post comments on this tracker with your current authentication level.

patch #3201: speed up results from mssql

Submitter:  Sigurd Nes <sigurdne>
Submitted:  Sun 11 Jul 2004 11:48:07 AM UTC
   
 
Category:  API - phpGWapi Priority:  5 - Normal
Item Group:  None Status:  Done
Privacy:  Public Assigned to:  skwashd
Open/Closed:  Closed

Sun 31 Oct 2004 02:09:57 PM UTC, comment #1: 

Added to proposed 18 branch

Dave Hall <skwashd>
Group administrator
Sun 11 Jul 2004 11:48:07 AM UTC, 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)

Sigurd Nes <sigurdne>
Group Member

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attached Files
file #7629:  mssql.diff added by sigurdne (698B - application/octet-stream - limit query by using 'TOP' for mssql)

 

Depends on the following items: None found

Items that depend on this one: None found

 

CC list is empty

 

There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

 

Follow 3 latest changes.

Date Changed by Updated Field Previous Value => Replaced by
2004-10-31 skwashd StatusNone Done
    Open/ClosedOpen Closed
2004-07-11 sigurdne Attached File- Added mssql.diff, #3451

Back to the top

Powered by Savane 3.13-caa5.
Corresponding source code