| Package home | Report new bug | New search | Development Roadmap | Status: Open | Feedback | All | Closed Since Version 0.9.3 |
| Request #14269 | Optimize subquery detection | ||
|---|---|---|---|
| Submitted: | 2008-06-30 19:52 UTC | ||
| From: | wiesemann | Assigned: | |
| Status: | Open | Package: | Structures_DataGrid (version CVS) |
| PHP Version: | Irrelevant | OS: | Irrelevant |
| Roadmaps: | (Not assigned) | ||
[2008-06-30 19:52 UTC] wiesemann
(Mark Wiesemann)
Description:
------------
User request: Change the regexp in the count() method of the SDG_DS_SQLQuery class so that only subqueries after the (first) FROM clause will be matched. Only such subqueries should affect the row count. (Needs to be verified, but the user and I can't think of any problematic case.) Advantage: Less queries that require the 'count_query' option or a query execution without a LIMIT clause.