General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>That works as long as the user is constantly querying looking at data, making adjustments and doing more queries. My idea is to let the user sort on ANY column in the grid simply by clicking on it. I would have to create too many indexes to do that (close to 240).
>
This is an interesting problem. I ran into something similar on a web page where the user wanted to be able to sort the data in any column (11 columns only on the web page), so rather than having to requery the data in a newly sorted order after each click on the header, I sent the data from the cursor down to the browser as XML and do the individual sorting with XSL. I mention this because the sorting is dynamic, as needed. You should be able to implement a routine that only indexes the data on the client side when the column is clicked. Once the index is generated, you don't have to reindex again. You might pre-index a few columns that might commonly be the sort criteria. The user could still sort on every column but might actually only do it on a few.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only