Like many web applications (business), the client wants to get a form that will search in each data field. A form can contain 15-20 different fields in which the user can select / enter / enter for use in sql (stored procedure).
These are fairly typical user requests that most applications have to deal with.
the problem really is how to provide the user with this type of interface / option AND establish fast SQL access. The above fields can span 15 different tables, and the corresponding sql statements (usually abbreviated for the stored procedure) will have the same number of joins. Data should always return to the grid type view, as well as to some report format (often superior).
We / find that these sql statements are slow and difficult to optimize, as the user can enter 1 or 15 different search criteria.
How to do it? Look for suggestions / ideas on how existing large applications cope with these requirements.
Is this really due to an attempt to optimize sql in a stored procedure?
thanks