phpGroupWare - 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: |
Dave Hall <skwashd> |
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> |
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 | Status | None | Done | |
Open/Closed | Open | Closed | |||
2004-07-11 | sigurdne | Attached File | - | Added mssql.diff, #3451 |
Powered by Savane 3.13-caa5.
Corresponding source code
Added to proposed 18 branch