Maniphest T280851

[SPIKE] Explore sqlite query planner behavior
Closed, InvalidPublic
Actions

Assigned To

None

Authored By

	BPirkle
	Apr 21 2021, 8:18 PM

Tags

Referenced Files

None

Subscribers

Description

Goal

Get experience on sqlite capabilities and its suitability for use in future PoC services

Acceptance Criteria

Determine sqlite query execution behavior and constraints, including use of indexes and efficiency of CPU/RAM usage for moderately complex queries (multiple joins) on moderately sized datasets (~10M rows)
Determine how (if at all) performing sqlite queries against views compares with similar queries against traditional tables
Determine how sqlite write performance is affected by multiple indexes
Determine if table size for moderately sized tables (~10M rows) noticeably affects sqlite performance of indexed queries
Document all findings on-wiki

The analysis performed for this task may also benefit T280849: [SPIKE] Evaluate toolforge performance capabilities and limitations and T280850: [SPIKE] Evaluate Cloud VPS performance capabilities and limitations

Related Objects

Mentioned In: T280850: [SPIKE] Evaluate Cloud VPS performance capabilities and limitations
T280849: [SPIKE] Evaluate toolforge performance capabilities and limitations
Mentioned Here: T280849: [SPIKE] Evaluate toolforge performance capabilities and limitations
T280850: [SPIKE] Evaluate Cloud VPS performance capabilities and limitations

Event Timeline

BPirkle created this task.Apr 21 2021, 8:18 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptApr 21 2021, 8:18 PM

BPirkle updated the task description. (Show Details)Apr 21 2021, 8:21 PM

BPirkle mentioned this in T280849: [SPIKE] Evaluate toolforge performance capabilities and limitations.

BPirkle mentioned this in T280850: [SPIKE] Evaluate Cloud VPS performance capabilities and limitations.

The bullets should probably be specific to sqlite right?

In T280851#7026679, @nnikkhoui wrote:

The bullets should probably be specific to sqlite right?

I added "sqlite" to each bullet point. See what you think.

• nnikkhoui updated the task description. (Show Details)Apr 26 2021, 3:25 PM

BPirkle added projects: Image-Suggestions, Image-Suggestion-API, Platform Team Workboards (Image Suggestion API).Apr 26 2021, 7:38 PM

Closing since this task was superseded by other image suggestions tasks. Please reopen if I'm mistaken.