PHPMem v2.0.1

Version
1.6.45
Uptime
15 days 9 hours 30 minutes 55 seconds

Memory

Total
512MB
Used
24,01MB (4.69%)
Free
487,99MB

Keys

Current
27 650
Total (since start)
33 978
Evictions
0
Reclaimed
160
Expired Unfetched
0
Evicted Unfetched
0

Connections

Current
11 / 1 024 max
Total
170 554
Rejected
0
llm:698a22478a86d1a0b31e97718f4df2c3d12b83650946d3b142ca4674e6d3ba50
TTL 4 days 9 hours 16 minutes 29 seconds Size 2,29KB Export
Edit
{
    "action": "final",
    "content": "## Most Important Metric and Category\n\n**Most Important Metric:** Aggregate rating (the core quality measure for restaurants)\n\n**Most Important Category:** City (actionable for market expansion decisions, with 147 distinct cities providing meaningful granularity)\n\n## How Rating Varies Across Cities\n\nThe analysis reveals significant variation in restaurant quality across cities:\n\n### Top-Performing Cities (by average rating):\n1. **Orlando** - 4.48 average rating (23,989 total votes)\n2. **Bangalore** - 4.38 average rating (56,115 total votes) \n3. **Dubai** - 4.37 average rating (18,693 total votes)\n4. **Chennai** - 4.32 average rating (27,695 total votes)\n5. **Kolkata** - 4.26 average rating (44,593 total votes)\n6. **Boise** - 4.26 average rating (10,381 total votes)\n\n### Lowest-Performing Cities:\n1. **Faridabad** - 1.87 average rating (6,486 total votes)\n2. **Noida** - 2.04 average rating (73,488 total votes)\n3. **New Delhi** - 2.44 average rating (628,340 total votes)\n4. **Gurgaon** - 2.65 average rating (132,160 total votes)\n\n### Key Insights:\n\n- **Rating range:** Cities span from 1.87 to 4.48 average rating - a 2.6-point spread on a 5-point scale, indicating substantial quality differences across markets\n\n- **Volume vs. Quality disconnect:** New Delhi has by far the most restaurants (5,473) and votes (628,340), but a below-average rating of 2.44. This suggests market saturation without corresponding quality\n\n- **International markets excel:** Cities like Orlando, Dubai, Bangalore, and international destinations consistently outperform the Delhi NCR region (New Delhi, Gurgaon, Noida, Faridabad)\n\n- **Actionable for expansion:** The data suggests opportunities in high-rated, lower-volume markets (e.g., Lucknow at 4.2, Guwahati at 4.19) where quality standards are high but restaurant density is lower\n\nThis metric-category pairing directly supports the dataset's stated decision use cases: identifying target cities for expansion and benchmarking restaurant performance against local competitors.",
    "charts": [
        {
            "kind": "hbar",
            "x": "City",
            "series": [
                "avg_rating"
            ],
            "title": "Average Restaurant Rating by City (Top 50)"
        }
    ]
}