Query Optimization Across Database Systems

363.0 GBP

363.0 GBP peopleperhour Technology & Programming Overseas
344 days ago

Description


I'm seeking guidance on understanding SQL Execution Plan reports generated by Dbeaver or similar tools. While I used these reports extensively over a decade ago, I've lost practice. Now, I need to optimize the time for a specific SQL set, and revisiting these reports with an expert will help refresh my understanding and enable me to make improvement suggestions.
I do not expect the freelancer to change existing scripts or access the DB but be able to make suggestions looking at the execution plans and the SQLs that will be delivered by me. Here the aim is to help me to remember how to do this so that I can do these evaluations and find bottlenecks myself.

Go Now
关注公众号,不定期副业成功案例分享
Follow WeChat

Success story sharing

Want to stay one step ahead of the latest teleworks?

Subscribe Now

Similar Teleworks

A WordPress website is experiencing issues with one of its pages. On www.loveledger.co.uk, the 'View Files' page functions incorrectly when a demo PIN is entered. While the uploaded images display as intended, the main homepage Content is erroneously duplicated beneath them. The client seeks a freelancer to diagnose and resolve this bug. Specifically, when the PIN triggers the 'View Files' functionality, only the intended file gallery should render, without reproducing homepage elements below it. The goal is to have the 'View Files' page operate seamlessly to exhibit uploaded media solely, clear of any extraneous homepage duplication interfering with the envisioned user experience on that particular interior page. Diagnosis of the underlying issue and provision of a clean fix are required. Experience with WordPress development, debugging anomalies, and optimizing page functionality would serve the task well.
20.0 GBP Technology & Programming peopleperhour Overseas
21 hour ago
1. Project Objective Design, build and deploy an AI‑driven LinkedIn workflow that automatically generates and delivers personalised lead magnets to three Ideal Customer Profiles (ICPs)—law‑firm owners, IT consultants, and accountancy‑practice partners—so you increase qualified conversations and booked calls. 2. Business Context Current outreach: Heyreach.io Campaign #1 – re‑engage 1st‑degree connections Heyreach.io Campaign #2 – nurture post reactors Existing lead magnets: Business Growth Quiz, “Create Clarity” Playbook, podcast episodes, case study, ChatGPT‑powered Exit Blueprint. Other tools in stack: LinkedIn Sales Navigator, Apollo.io, Clay, Trigify. Strategic hook: Each ICP advises founders who want to scale and exit but lack a structured exit strategy; lead magnets must surface that pain and position your “scale‑to‑exit framework.” 3. Desired Future Workflow (high‑level) Detection Trigger on new 1st‑degree connection, post reaction, or saved search match. Enrichment & ICP Classification Pull firmographics via Apollo / Clay API (industry, headcount, role). Classify into ICP‑Law, ICP‑IT, ICP‑Accountancy (fallback = “Other”). Personalised Lead‑Magnet Generation Use OpenAI API (GPT‑4o) + prompt templates to create: A bespoke 2‑page PDF mini‑playbook (pain points + quick wins). A unique share‑link to your tailored ChatGPT Exit Blueprint (pre‑loaded with their context). Asset Production Render PDF via serverless doc generator (e.g., Documint, PDFLib, or HTML‑>Puppeteer). Store in S3 / CloudFront; capture public URL. Delivery Sequencing (via Heyreach) Day 0 DM: pattern‑interrupt hook + quiz link. Day 2 Auto‑follow‑up: drop personalised PDF link. Day 5 Nudge: invite to 15‑min “Exit Readiness Review” call. Feedback Loop Sync engagement data back to Airtable/CRM; score lead; auto‑stop on meeting booked. 4. Functional Requirements # Requirement Notes F1 Identify contact ICP via enrichment API and keywords in LinkedIn headline < 300 ms per contact F2 Generate PDF lead magnet with dynamic sections: intro, pain diagnostic, 90‑day action plan, CTA Template must support variable brand colours F3 Create custom GPT blueprint link pre‑seeded with firm name + challenges Use OpenAI “file‑based” system prompt F4 Push asset links + personalised copy back into Heyreach via webhook Must merge‑tag into existing campaign templates F5 Log all events to central datastore (Postgres or Airtable) For reporting & A/B testing 5. Non‑Functional Requirements Security & GDPR: No PII stored outside EU data centres without encryption at rest & TLS 1.2+. Scalability: 2 000 contacts/day with 80 % coverage) Prompt Engineering Library (YAML/JSON templates) CI/CD Pipeline (GitHub Actions) incl. lint, tests, security scan, deploy Admin Dashboard (low‑code Retool) showing pipeline stats & lead downloads Playbook (PDF/Notion) for Marketing Ops: how to create/edit templates 30‑day Hypercare Support 8. Success Metrics (90‑day post‑go‑live) 30 % ↑ in qualified meetings booked from LinkedIn. ≥25 % click‑through on personalised PDFs. Lead magnet production cost ≤ $0.45 per contact (compute + API). System uptime ≥ 99.5 %. 9. Timeline & Milestones Week Milestone 1 Requirements finalised, access to APIs provisioned 2 MVP pipeline: enrichment → content generation → asset storage 3 Heyreach integration & DM templates wired 4 PDF branding polish + dashboard 5 End‑to‑end QA, GDPR review 6 Pilot on 200 contacts 7 Iterate, performance tuning 8 Full launch + hand‑off 10. Risks & Mitigations LinkedIn API/ToS changes: Use headless browser fallback script; monitor rate limits. OpenAI pricing spikes: Add Claude Sonnet or open‑source fallback in abstraction layer. Personalisation fatigue: Rotate prompt templates quarterly; A/B test offers. 11. Next Steps Confirm or adjust scope & KPIs. Provide dev with API keys & brand assets (logo, colours, fonts). Schedule weekly stand‑up cadence and shared Slack channel (doesn't necessarily have to be slack) Must have experience in multiple LLMs
363.0 GBP Technology & Programming peopleperhour Overseas
2 days ago
✅ Job Posting for Dog Walking Schedule & Earnings Tracker Setup Title: Need Simple Dog Walking Schedule & Earnings Tracker — Mobile Friendly Description: I need a simple, easy-to-use schedule and earnings tracker for my dog walking services. I want this set up in a tool like Google Sheets, Notion, or Excel that I can easily access and update on my phone. Here’s what I need: • A monthly schedule layout with days of the week (Monday-Sunday) and dates. • Dropdown menus for service types (Dog Walk, Drop-In, Overnight, Day Sit). • Fields for dog name, notes, and earnings for each service. • Automatic earnings calculation based on service type (e.g., £20 for a Dog Walk, £15 for a Drop-In). • A weekly and monthly earnings summary that updates automatically based on the services I enter. • Simple, clean, and easy to use — nothing too complicated. • Must be fully accessible and editable on a phone. Budget: £20 Deadline: Ideally within 3-5 days.
15.0 GBP Technology & Programming peopleperhour Overseas
1 days ago

HuntsBot,a one-stop outsourcing task, remote job, product ideas sharing and subscription platform, which supports DingTalk, Lark, WeCom, Email and Telegram robot subscription. The platform will push outsourcing task requirements, remote work opportunities, product ideas to every subscribed user with timely, stable and reliable.

简体中文 English

Platform

Support

Links

Contact US

Any questions or suggestions during use, you can contact us in the following ways:

Email: huntsbot@xinbeitime.com

Copyright© 2022-2023 www.huntsbot.com 浙ICP备2022000860号-4 All Rights Reserved.