惯性聚合 高效追踪和阅读你感兴趣的博客、新闻、科技资讯
阅读原文 在惯性聚合中打开

推荐订阅源

博客园 - 三生石上(FineUI控件)
S
SegmentFault 最新的问题
阮一峰的网络日志
阮一峰的网络日志
freeCodeCamp Programming Tutorials: Python, JavaScript, Git & More
钛媒体:引领未来商业与生活新知
钛媒体:引领未来商业与生活新知
雷峰网
雷峰网
Apple Machine Learning Research
Apple Machine Learning Research
WordPress大学
WordPress大学
博客园 - 司徒正美
奇客Solidot–传递最新科技情报
奇客Solidot–传递最新科技情报
宝玉的分享
宝玉的分享
爱范儿
爱范儿
月光博客
月光博客
The GitHub Blog
The GitHub Blog
M
MIT News - Artificial intelligence
H
Hackread – Cybersecurity News, Data Breaches, AI and More
B
Blog
T
Tailwind CSS Blog
美团技术团队
D
Docker
V
Visual Studio Blog
Martin Fowler
Martin Fowler
博客园 - 聂微东
The Cloudflare Blog

DEV Community

Authentication Security Deep Dive: From Brute Force to Salted Hashing (With Java Examples) Why AI Systems Don’t Fail — They Drift Spilling beans for how i learn for exam😁"Reinforcement Learning Cheat Sheet" I Replaced Chrome with Safari for AI Browser Automation. Here's What Broke (and What Finally Worked) How Python Borrows Other People's Work The $40 Architecture: Processing 1 Billion API Requests with 99.99% Uptime Vibe Coding: A Workflow Guide (From Zero to SaaS) Most webhook security guides protect the wrong side. The scary part is delivery. Headless CMS for TanStack Start: Build a Blog with Cosmic EU Age Verification App "Hacked in 2 Minutes" — What Actually Happened Comfy Cloud’s delete function does not actually remove files Running AI Models on GPU Cloud Servers: A Beginner Guide Event-driven media intelligence with AWS Step Functions and Bedrock I scored 500 AI prompts across 8 quality dimensions — here's what broke How to Call Google Gemini API from Next.js (Free Tier, No Backend Needed) The Portal Protocol: Reclaiming Human Connection in the Age of AI How to Fix Your Team's Scattered Knowledge Problem With a Self-Hosted Forum Intro to tc Cloud Functors: A Graph-First Mental Model for the Modern Cloud Designing Multi-Tenant Backends With Both Ownership and Team Access I Built a Neumorphic CSS Library with 77+ Components — Here's What I Learned PostgreSQL Performance Optimization: Why Connection Pooling Is Critical at Scale Cómo construí un SaaS multi-rubro para gestionar expensas en Argentina con FastAPI + Vue 3 🚀 I Built an Ethical Hacking Scanner Tool – Open Source Project I Replaced /usage and /context in Claude Code With a Single Statusline A Pythonic Way to Handle Emails (IMAP/SMTP) with Auto-Discovery and AI-Ready Design I Collected 8.9 Million Polymarket Price Points — Here's What I Found About How Markets Really Move EcoTrack AI — Carbon Footprint Tracker & Dashboard Everyone's Using AI. No One Agrees How. 5 self-hosted ebook managers worth trying in 2026 Building Your First AI Agent with LangChain: From Chatbot to Autonomous Assistant
Devlog: Performance Optimization Lessons from ADHD App Be...
Dopami · 2026-06-17 · via DEV Community

Dopami

TL;DR: The biggest performance and reliability work was not a fancy animation pass. It was fixing the task recommendation pipeline: removing non-translatable scoring logic from EF Core queries, sorting after real personalized scores are computed, making activity patterns accumulate correctly, syncing user timezones, and using due dates as a real urgency signal.

Why Performance Matters in an ADHD App

Dopami is a soft-gamified chore app built for ADHD users.

In this kind of app, performance is not just polish. If the app hesitates at the moment someone is ready to act, the motivation window can close. The goal is simple: when the user opens the app, the next useful task should appear quickly, feel relevant, and not require extra thinking.

During the beta-hardening phase, I found several issues in that exact path.


Fix 1: EF Core Crash in Personalized Task Scoring

Problem: some task-listing endpoints were trying to call the C# scoring service inside an EF Core LINQ projection.

That is a classic trap: EF Core can translate SQL expressions, but it cannot translate arbitrary C# service logic.

When that logic leaks into the query, the endpoint can crash at runtime because EF Core does not know how to turn it into SQL.

Fix: split the work into two phases.

  1. Let SQL do what SQL is good at: filtering, counting, includes, and coarse candidate ordering.
  2. Materialize the tasks.
  3. Map them to DTOs.
  4. Apply the personalized score in memory.

This fixed the runtime crash and made the scoring path explicit: database first, personalization second.


Fix 2: Correct Personalized Sorting Before Pagination

Problem: the assigned tasks endpoint was paginating too early.

That meant the app could fetch a page of tasks first, then score only that page. But for a recommendation system, this is wrong: the best task might be on page 2 or 3 before scoring.

Fix: load a bounded candidate set, score it in memory, then paginate after sorting by score.

This keeps the endpoint efficient while making the result much more relevant.

The SQL query still applies a cheap pre-sort based on urgency and impact.

Then the app applies the full personalized score with activity patterns, preferred reminder hours, day-of-week patterns, routine context, and due-date urgency.


Fix 3: Activity Patterns Were Not Reliable Enough

The recommendation system depends on knowing when a user usually completes tasks.

Problem: the activity-pattern logic had edge cases that could prevent the user’s completion history from being used correctly. One issue was treating hour-based patterns like an array index instead of looking up the pattern by HourOfDay.

Fix: score the current local hour by looking up the matching pattern.

That made the score reflect the actual hour bucket instead of accidentally depending on list position.

I also fixed the completion recording path so existing patterns are incremented instead of losing useful history.

This matters because personalization only becomes useful if the app actually remembers behavior over time.


Fix 4: Timezone-Aware Scoring and Reminders

A task reminder system cannot use raw UTC hours and pretend that is the user’s day.

Problem: the backend had scoring logic based on local hour, but the user’s UTC offset was not fully wired through the profile/update flow.

Fix: add UtcOffsetHours to the user DTO, profile update model, backend update path, and mobile auth context.

On app startup, the mobile client now compares the device timezone offset with the saved user offset and silently syncs it when needed.

This makes “good time to suggest this task” much more meaningful.

A reminder at 9 AM should mean 9 AM for the user, not 9 AM for the server.


Fix 5: Due Dates Became a Real Priority Signal

Due dates were present in the data model, but the write path and mobile form were not fully wired.

Fix: connect due dates end to end:

  • backend TaskFormModel
  • task creation/update service
  • mobile TaskFormRequest
  • task composer state
  • task cards and metadata labels
  • scoring urgency

Now due dates affect both display and ranking. A task due soon can rise naturally in the list without needing a separate “panic mode” UI.


What This Changed

The main improvement was not one magic optimization. It was making the recommendation pipeline honest:

  • SQL handles filtering and bounded candidate selection.
  • C# handles personalized scoring after materialization.
  • Pagination happens after scoring, not before.
  • Activity history is recorded correctly.
  • Local time is actually local.
  • Due dates influence priority.

For an ADHD app, that matters because the home screen is not just a list. It is a decision-reduction tool.

The user should not have to scan 40 chores and negotiate with themselves. The app should be able to say: “start here.”


Beta still open → do-pami.com/beta