CUAHSI / CUAHSI/HydroServerLite
Web service speed problem - big database
- Dominant language
- PHP
- Stars
- 7
- Forks
- 6
- PR merge metrics
- No merged PRs in 30d
Description
jirikadlec2[CodePlex]
If the MySQL ODM database is big (datavalues table has gt 1 million rows) then it takes a few minutes to download the data for one variable and one site and the GetValues request sometimes doesn't complete due to server timeout error.
suggested solutions:
optimize the GetValues SQL queries
profile the queries
add indexes to the columns in the datavalues table that are used in the JOIN query statements.
Contributor guide
No contributing guide indexed for this repository
Research direction
Start at the GetValues request and trace the SQL involving the datavalues table. Profile the queries against a database with more than one million rows, then inspect the JOIN columns and existing indexes. Done means retrieving one variable and site completes reliably without a server timeout.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- mysql, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100