Performance Optimization Request

[TryOmar]

Performance Optimization Request

We want to improve the overall performance of LabShare.

If you have simple ideas to make the website faster (load time, API speed, queries, caching, images, etc.), please share them here.

Thanks!

[TryOmar]

Note: We improved performance before in PR #27, and we're looking for more optimization ideas.

[SlowWebDev]

المشكلة: استعلام في داتا بيز زياده بيقلل الأداء
الملف ال في المشكله
(app/api/dashboard/routs.ts)
الكود الحالي الموجود التالي

    // Get lab IDs filtered by course_id in SQL - all filtering in database
    const { data: labsData, error: labsError } = await supabase
      .from("labs")
      .select("id")
      .in("course_id", courseIds);

    if (labsError) {
      console.error("Error fetching labs:", labsError);
      // Continue without lab filtering - will fetch all submissions
    }

    // Extract lab IDs from SQL result - minimal JS processing (single map)
    const labIds = (labsData || []).map((lab: any) => lab.id);

    // Fetch submissions with all filtering done in SQL
    // Database calculates limit: 10 per course * number of courses + buffer
    const limitEstimate = Math.max(100, courseIds.length * 15);

    // Build submissions query with all filtering in SQL
    let submissionQuery = supabase
      .from("submissions")
      .select(
        `
        *,
        students(id, name, email),
        labs!inner(id, lab_number, title, course_id, courses(id, name))
      `
      )
      .order("created_at", { ascending: false })
      .limit(limitEstimate);

    // Filter by lab_id at database level (all in SQL)
    if (labIds.length > 0) {
      submissionQuery = submissionQuery.in("lab_id", labIds);
    }

في مشكله هي بيرسل طلب ل داتا بيز لطلب أرقام
(labs)
وبيستنى الرد عشان يستعملو ويجيب
(submissions)

وده بيعمل ديلاي ممكن يقل

الحل: الغاء الانتظار وندمجهم
حذف الاستعلام البيجيب ارقام ال
(labs)
وتستعمل ال
(submission)
فقط وده هيخلي طلب واحد ويقلل deley

[TryOmar]

Thanks a lot @SlowWebDev 🤍
Great catch! We'll consider removing the extra labs query and relying only on submissions to reduce delay. Appreciate it!