Perfomatic:Schema Notes: Difference between revisions
Jump to navigation
Jump to search
| Line 6: | Line 6: | ||
* Archiving policy? | * Archiving policy? | ||
** How much access do we need to old data | ** How much access do we need to old data | ||
** How fast does the database grow? | |||
* Sharding | * Sharding | ||
** Do we need a row per result? | ** Do we need a row per result? | ||
Revision as of 21:34, 17 July 2008
Schema Notes
- Need someone who uses the graph server every day -- need use-cases (vlad or stuart)
- Need to know how it's used, what are the common user goals
- Need to identify any front-end requirements that would affect the back-end schema
- Questions for people who made the schema in the first place
- Archiving policy?
- How much access do we need to old data
- How fast does the database grow?
- Sharding
- Do we need a row per result?
- Partitions?
- Chunk results into 10,000 seconds? Why have a row per result set?
- Use simples files for a certain subset of tests -- why use mysql at all?