Priority: High
Difficulty: Intermediate
Type: Backend (Node.js + MongoDB + Mongoose)
Description
We need to add an index on the collections field in the Product schema.
This will improve performance for queries like /api/collections/:name since contributors and users will often fetch products by collection.
Implementation Details
-
Update Product Schema
- Current field:
collections: { type: [String], default: [] }
- Add an index:
productSchema.index({ collections: 1 });
-
Verify Index Creation
- After updating schema, restart backend.
- Run in Mongo shell or Compass:
You should see the new index for
collections.
-
Testing
- Query endpoint
/api/collections/:name.
- Ensure API works as before.
- Confirm queries run faster in Mongo logs / Compass (optional).
Acceptance Criteria
collections field has an index in MongoDB.- Queries to
/api/collections/:name work as expected.
- Verified via
db.products.getIndexes() that index exists.
- Code passes existing ESLint/Prettier rules.
Priority: High
Difficulty: Intermediate
Type: Backend (Node.js + MongoDB + Mongoose)
Description
We need to add an index on the
collectionsfield in theProductschema.This will improve performance for queries like
/api/collections/:namesince contributors and users will often fetch products by collection.Implementation Details
Update Product Schema
Verify Index Creation
collections.Testing
/api/collections/:name.Acceptance Criteria
collectionsfield has an index in MongoDB./api/collections/:namework as expected.db.products.getIndexes()that index exists.