- Status Closed
- Percent Complete
- Task Type Feature Request
- Category Backend / Core
-
Assigned To
pizza - Operating System All
- Severity Low
- Priority Very Low
- Reported Version Devel
- Due in Version Undecided
-
Due Date
Undecided
- Votes
- Private
FS#55 - Speed up searches with temporary tables/views
Once a search is complete, cache the results in a temp table so we don't have to re-perform the search when we're paging through the results.
Closed by pizza
2007-03-23 03:43
Reason for closing: Won't implement
Additional comments about closing: It's not going to happen, at least not this way.
2007-03-23 03:43
Reason for closing: Won't implement
Additional comments about closing: It's not going to happen, at least not this way.
Loading...
Available keyboard shortcuts
- Alt + ⇧ Shift + l Login Dialog / Logout
- Alt + ⇧ Shift + a Add new task
- Alt + ⇧ Shift + m My searches
- Alt + ⇧ Shift + t focus taskid search
Tasklist
- o open selected task
- j move cursor down
- k move cursor up
Task Details
- n Next task
- p Previous task
- Alt + ⇧ Shift + e ↵ Enter Edit this task
- Alt + ⇧ Shift + w watch task
- Alt + ⇧ Shift + y Close Task
Task Editing
- Alt + ⇧ Shift + s save task
What I have in mind -- create a new table, search_results { user_id, search_id, image, search_time }, and that would be populated with the list of matching images.
When a user performs a search, we erase the results of searches performed more than, say, 24 hours ago.
Sorting order would be performed on the final view.
search_id would be a sequence, naturally. the search_results table would need to be global.
temporary tables only last out the current "session", which is to say they'd go away as soon as the page is loaded, thanks to the non-persistent nature of our database connections.
We need to expand this to include a blob that contains the search parameters too. (eg advanced search, with X, Y, Z parameters)
OR, we can use the new session code; store the search results in the session. ooooo.
this simplifies (and vastly speeds up) the search code considerably!