How lacdudinh23-jimo/indexing-strategy works
This is a browser-based MySQL indexing demo. Users generate sample book rows, choose a query scenario, and compare full-scan and indexed benchmark results, including plans, timing, build cost, and index size. The frontend coordinates the workflow through a PHP JSON API; the API performs database setup, generation, query planning, and measurement against MySQL. Other advertised algorithm descriptions are frontend content, while the executable benchmark scenarios shown are ISBN, price, and title. HTML and styling are present in the tree, but their behavior is not established by the excerpts.
Main entry points: api.php JSON API · db.php DB connection · script.js Workflow controller · index.html Demo interface
Components 7
Browser interface
- Demo interface
index.html - Workflow controller
script.js
API and benchmark
- JSON API
api.php
MySQL storage
- DB connection
db.php - Books table
db.php
Other components
- Demo user
- MySQL server
Connections 8
- Demo user → Demo interface: uses
- Demo interface → Workflow controller: hosts controller
- Workflow controller → JSON API: POST actions
script.js - JSON API → DB connection: requires setup
api.php - JSON API → Books table: queries and mutates
api.php - DB connection → MySQL server: connects
db.php - DB connection → Books table: creates and selects
db.php - JSON API → Workflow controller: returns JSON results
script.js