Support report for high-volume query optimization
Platform-managed indexes
Base44 manages database indexes and does not expose direct index creation. This report lists the fields that need indexes, their usage, and expected performance benefit. Copy the support message below and send it to Base44 support to request index creation.
| Entity | Field | Query | Usage | Benefit | Urgency |
|---|---|---|---|---|---|
| Product | active_status | Product.filter({ active_status: true }) | Every marketplace product listing, home page, search results | Eliminates full-collection scan on the most frequent customer query | Critical |
| Product | category_id | Product.filter({ category_id, active_status: true }) | Category browsing, category-filtered search | Fast category-scoped product retrieval | High |
| Product | boutique_id | Product.filter({ boutique_id }) | Boutique page product grid, vendor dashboard | Fast boutique-scoped product listing | High |
| Boutique | publication_status | Boutique.filter({ publication_status: 'published' }) | Marketplace boutique listing, home page, search | Filters published boutiques without full scan | Critical |
| Boutique | approval_status | Boutique.filter({ approval_status: 'Approved' }) | Super Admin vendor management, published boutique validation | Fast admin vendor filtering | Medium |
| Order | buyer_user_id | Order.filter({ buyer_user_id }) | Customer dashboard order list (every customer login) | Fast customer order history retrieval | Critical |
| Order | vendor_user_id | Order.filter({ vendor_user_id }) | Vendor dashboard order list (every vendor login) | Fast vendor order history retrieval | Critical |
| Order | order_number | Order.filter({ order_number }) | Payment success reconciliation, order tracking, webhook dedup | Fast order lookup by human-readable number | Critical |
| EscrowPayment | order_id | EscrowPayment.filter({ order_id }) | Escrow lookup on order view, settlement service, payout eligibility | Fast escrow-to-order join | High |
| Cart | user_id | Cart.filter({ user_id, cart_status: 'active' }) | Every authenticated customer page load (cart sync) | Fast active-cart lookup per user | Critical |
| DeliveryMission | order_id | DeliveryMission.filter({ order_id }) | Delivery tracking, order detail page, delivery monitor | Fast delivery mission lookup by order | High |
| NotificationLog | order_id | NotificationLog.filter({ order_id }) | Notification history per order, dedup checks | Fast notification lookup by order | Medium |
Hello Base44 Support,
We are preparing the AfrikaBizz marketplace for production scale and need database indexes created on the following high-volume fields. The platform does not expose direct index creation, so we are requesting your assistance.
Please create indexes on the following entity fields:
1. Product.active_status
Query: Product.filter({ active_status: true })
Usage: Every marketplace product listing, home page, search results
Expected benefit: Eliminates full-collection scan on the most frequent customer query
Urgency: Critical
2. Product.category_id
Query: Product.filter({ category_id, active_status: true })
Usage: Category browsing, category-filtered search
Expected benefit: Fast category-scoped product retrieval
Urgency: High
3. Product.boutique_id
Query: Product.filter({ boutique_id })
Usage: Boutique page product grid, vendor dashboard
Expected benefit: Fast boutique-scoped product listing
Urgency: High
4. Boutique.publication_status
Query: Boutique.filter({ publication_status: 'published' })
Usage: Marketplace boutique listing, home page, search
Expected benefit: Filters published boutiques without full scan
Urgency: Critical
5. Boutique.approval_status
Query: Boutique.filter({ approval_status: 'Approved' })
Usage: Super Admin vendor management, published boutique validation
Expected benefit: Fast admin vendor filtering
Urgency: Medium
6. Order.buyer_user_id
Query: Order.filter({ buyer_user_id })
Usage: Customer dashboard order list (every customer login)
Expected benefit: Fast customer order history retrieval
Urgency: Critical
7. Order.vendor_user_id
Query: Order.filter({ vendor_user_id })
Usage: Vendor dashboard order list (every vendor login)
Expected benefit: Fast vendor order history retrieval
Urgency: Critical
8. Order.order_number
Query: Order.filter({ order_number })
Usage: Payment success reconciliation, order tracking, webhook dedup
Expected benefit: Fast order lookup by human-readable number
Urgency: Critical
9. EscrowPayment.order_id
Query: EscrowPayment.filter({ order_id })
Usage: Escrow lookup on order view, settlement service, payout eligibility
Expected benefit: Fast escrow-to-order join
Urgency: High
10. Cart.user_id
Query: Cart.filter({ user_id, cart_status: 'active' })
Usage: Every authenticated customer page load (cart sync)
Expected benefit: Fast active-cart lookup per user
Urgency: Critical
11. DeliveryMission.order_id
Query: DeliveryMission.filter({ order_id })
Usage: Delivery tracking, order detail page, delivery monitor
Expected benefit: Fast delivery mission lookup by order
Urgency: High
12. NotificationLog.order_id
Query: NotificationLog.filter({ order_id })
Usage: Notification history per order, dedup checks
Expected benefit: Fast notification lookup by order
Urgency: Medium
These indexes are critical for our customer-facing pages to perform well under production load. The most urgent are Product.active_status, Boutique.publication_status, Order.buyer_user_id, Order.vendor_user_id, Order.order_number, and Cart.user_id — these are queried on nearly every page load.
Thank you,
AfrikaBizz Team