
Completed
Posted
Paid on delivery
Our mobile application serves both iOS and Android users, with the iOS build written in Swift. Lately we’ve noticed sluggish start-up times and sporadic connection drops that point to backend configuration rather than client-side code. Here’s what I need you to dive into: • DATABASE_URL and Prisma connection settings – check pool size, keep-alive, and any mis-typed env variables, then fine-tune them for production traffic. • TLS and timeout configuration – verify certificates, cipher suites, and server timeouts so every request completes securely and quickly. • Smooth restarts – after each change, restart the services (and the mobile builds if required) to confirm fixes hold under load. Deliverables: 1. Updated config files (.env, TLS cert or nginx/apache/conf snippets) committed or supplied back. 2. A brief report summarising the changes, why they were required, and the performance delta observed. 3. Confirmation that both iOS and Android builds connect cleanly with no new warnings or errors. Access to the code repository, staging environment, and current logs will be provided as soon as we start. If you spot anything else that could shave milliseconds or improve stability, flag it and we can schedule an extra pass.
Project ID: 40757062
83 proposals
Remote project
Active 7 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hi Thanks for your valuable time. :-) We are going to study your given details and update you with our comments. If you have more detail to add then please provide - so we can take it into consideration during our study. If you would like to setup meeting then Can you please suggest time between 11am to 8pm IST ? I will provide you nice UI/UX design, high coding standard and If there will be need of CMS then will develop it as per project-flow. Here are some live urls : [login to view URL] Latest Apps : [login to view URL] We are team of developers and You will directly work with your Technical Team. :-) I am not just looking for money or 1 project - I believe in long term business relationship. Why should you hire Me : [login to view URL] Update you soon - Have a great day. Regards, Dushyant. KESHAV INFOTECH
$66 USD in 7 days
9.5
9.5
83 freelancers are bidding on average $133 USD for this job

Hello, I am Dr. Rajesh Rolen, PhD in Computer Science & Engineering, with experience of over 20+ years in Android, Mobile App Development, iPhone, Swift, Backend Development As a preferred freelancer in the top 1%, I have done 400+ projects here on freelancer.com, I have 4.9 ratings out of 5 on average, which showcases my quality of work and timely delivery. Key Highlights: - Free Hosting Support on the Cloud or any desired platform. - Free 3 months of post-delivery support to ensure that our client doesn’t face any challenges after the launch of the project. - Free Dedicated tester on projects to ensure quality delivery, so clients don’t need to act as a tester. - 10+ Years experience UI/UX team to ensure intuitive UI. Portfolio: https://www.freelancer.com/u/Microlent Please open the chat and send me a message, so we can have a more detailed discussion about the project to give you the project timeline and cost. Thank you for considering my services. I look forward to engaging in a productive conversation and understanding how I can be of assistance in bringing your project to life. Regards Rajesh Rolen
$140 USD in 10 days
9.4
9.4

BACKEND PERFORMANCE ENGINEER I have excellent experience tuning production backends, especially PRISMA CONNECTION POOLING, DATABASE_URL settings, and TLS and timeout configuration that cause slow startups and random connection drops. My plan: audit your env variables and pool size, keep-alive and idle timeout settings first, then check certificates, cipher suites and nginx or apache timeouts. After each change I will restart services, test under load, and confirm both iOS and Android connect cleanly. You will get the updated config files and a short report showing what changed and the PERFORMANCE DIFFERENCE measured. QUESTIONS — is the database managed (like RDS or Supabase) or self-hosted, and do you already have logs or metrics showing when the connection drops happen most? Plesae ping to discuss the requirement timeframe and the budget also. Thanks!!!
$250 USD in 7 days
7.5
7.5

Hi, could you please share the current backend stack, Prisma version and hosting environment so I can review the connection, TLS and timeout configuration? I can audit and optimize your production backend configuration, including DATABASE_URL, Prisma connection pooling, keep-alive settings, environment variables, TLS certificates, cipher suites and server timeouts. I’ll apply changes safely in staging, restart services, test under load and verify that both iOS and Android connect reliably without introducing new errors. -/ Which server stack are you using, such as Nginx, Apache, Node.js or another setup? -/ Are the connection drops affecting both iOS and Android or mainly one platform? -/ Do you have recent server logs and current performance/start-up measurements available? Best regards, Asif Ali Zaman Budget and Duration: TBD
$160 USD in 4 days
7.3
7.3

Sluggish app startup and random connection drops usually come from backend config drift, not the mobile code itself, so your focus on Prisma, TLS, and timeout settings makes sense. I’d start by auditing DATABASE_URL/env values, pool and keep-alive behavior, then trace how TLS and server timeout settings are affecting connection stability under repeat requests. I’ve handled this kind of backend troubleshooting for app and web stacks where the visible symptom was “the app feels slow” but the actual cause was pooling limits, bad env naming, stale cert config, or overly aggressive timeout values. The useful part is not just changing settings, but validating that both iOS and Android reconnect cleanly after restarts and that no fresh warnings appear in logs. I can also flag any extra low-effort wins if I spot them during the pass. - Is Prisma sitting behind Postgres or MySQL here? - Are you running nginx or Apache in front of the app service? - Do you already have baseline startup/response timings from staging so the delta can be measured cleanly?
$180 USD in 4 days
6.5
6.5

Hi, the sluggish startup and intermittent connection drops sound like issues worth tracing through the backend connection layer first. We can review your **Prisma/DATABASE_URL configuration, connection pooling, keep-alive settings, environment variables, TLS, and server timeouts**, then validate the changes against your staging environment and logs. Our team has hands-on experience with **Node.js, APIs, databases, Linux servers, backend troubleshooting, and mobile applications**. While our mobile development is primarily Flutter/React Native rather than native Swift, we can focus on the backend/infrastructure issues affecting both your iOS and Android clients. We’ll provide the updated configuration files along with a concise report of the changes, findings, and performance/stability improvements observed during testing. We can start by reviewing the current configuration and logs to identify the actual bottleneck before making changes.
$140 USD in 7 days
7.6
7.6

Hi, The key risk is treating this as a simple pool-size increase. With Prisma, the effective connection count is pool size multiplied by the number of running application instances; increasing it blindly can exhaust the database during traffic spikes or rolling restarts and make the connection drops worse. I’ll first correlate startup and disconnect timestamps across application, database, proxy, and TLS logs, then verify DATABASE_URL parsing, database connection limits, instance count, and timeout alignment. This will distinguish pool saturation from stale connections, TLS negotiation delays, or a proxy closing idle sessions earlier than Prisma expects. Changes will be validated under repeatable cold-start, sustained-load, and restart tests, with before/after measurements rather than subjective improvement. I’ll also verify the certificate chain and connections from both platforms. Mobile rebuilds should only be needed if endpoint, trust, or client configuration changes; otherwise backend restart and device-level connection testing avoid unnecessary release work. You’ll receive production-ready config changes, a concise rationale and performance report, plus confirmation of clean iOS and Android connectivity. Thanks!
$50 USD in 1 day
6.3
6.3

Hi , Good morning! I am skilled mobile engineer with skills including iPhone, Backend Development, Mobile App Development, Database Management, Android, Linux, Swift and iOS. Please contact me to discuss more regarding this project. Please respond at your earliest convenience
$155 USD in 3 days
5.8
5.8

Hello, I'm Denis, a full-stack developer, and I have optimized backend configurations for mobile apps to cut startup times and eliminate connection instability. Your iOS and Android users are hitting slow starts and dropped connections, which suggests the backend setup is not tuned for production load. You need the database pool, TLS certificates, and timeouts checked and adjusted, then verified to work cleanly with both builds before anything breaks in production. I would start by reviewing your current DATABASE_URL, Prisma settings, and environment variables to spot misconfigurations. Then I would audit the TLS certificates, cipher suites, and server timeouts, adjust them for your traffic pattern, and update the config files. After each change, I would restart the services and test both iOS and Android builds to confirm the fixes hold under load and produce no new warnings. The critical part is the database connection pool. If it is too small, requests queue and timeout; if it is too large, you waste memory and create instability. I would size it based on your expected concurrent users and measure the improvement before and after. One realistic risk is that logs might not show the root cause clearly, so I would also check application-level timeouts and keep-alive settings to rule out edge cases. I can start working right away. Let's connect and discuss the details. Thanks, Denis.
$30 USD in 2 days
6.0
6.0

Hey, A bigger Prisma connection pool is a common fix that makes things worse. If the database sits behind a pooler or on a managed plan, each extra connection counts against a hard limit, and under load the app starts timing out. That looks just like the connection drops you're seeing, so the right pool size depends on the database's own limit and how many server instances run. I'd read the logs and the connection count against the database limit first, then change the pool, keep alive and timeout settings in small steps on staging, measuring start up time after each. The same pass would check the TLS certificate chain and the server timeouts. I can start as soon as I have staging and log access. Which database and host is it on, and is a pooler like PgBouncer in front of it? Do the drops happen at set times, like after a quiet period or at peak, or at random?
$90 USD in 2 days
6.0
6.0

Hi there, I noticed you're looking to optimize the backend performance of your mobile application, specifically focusing on the DATABASE_URL and Prisma connection settings. I have extensive experience in fine-tuning database connections for optimal performance, ensuring pools are correctly sized and all environment variables are accurately configured. Additionally, I can assess your TLS and timeout configurations to ensure security and performance are not compromised, which is crucial for both Android and iOS users. I will deliver updated config files, a summarizing report on the changes, and confirmation of successful connections across both platforms. If any further optimizations are identified during this process, I’ll be sure to flag those for discussion as well. I'm ready to start once you provide access to the code repository and current logs. Regards, Ali
$90 USD in 1 day
5.1
5.1

Hi, I can handle this as a targeted backend configuration and stability pass without unnecessarily touching the Swift, Android, or application logic. I’d start by tracing the intermittent connection drops through the logs and current deployment configuration, then audit DATABASE_URL, Prisma connection pooling, connection limits, keep-alive behavior, and environment-variable mismatches. I’d also review the TLS/reverse-proxy configuration and request, upstream, and idle timeouts for settings that could cause slow starts or dropped connections. After each controlled change, I’ll restart the relevant services and validate the staging environment from both iOS and Android clients. I’ll also compare startup/request timings before and after the changes so the report contains an actual performance delta rather than just a list of configuration edits. What backend/runtime and hosting stack are you using, and is nginx or Apache currently handling TLS? Ready to start immediately.
$140 USD in 7 days
5.6
5.6

Hello, I have already completed similar projects involving Prisma, database connections, environment configuration, TLS, server timeouts, and mobile API connectivity. I have strong experience in web development, APIs, and scalable software solutions. I can quickly review your logs and staging environment, identify the connection issues, adjust the production settings, and verify everything on both iOS and Android. Are you currently using PostgreSQL with Prisma, or a different database? I can provide the updated configuration files and a clear report of the changes and results. Happy to discuss the work in a quick meeting. I will share my portfolio in chat I look forward to hear from you. Thanks Best Regards, Mughira
$140 USD in 7 days
5.1
5.1

Hi, I can troubleshoot and optimize the backend connectivity issues affecting your iOS and Android apps, focusing on the Prisma/PostgreSQL connection layer, TLS and server timeouts rather than making unnecessary client-side changes. I’ll audit DATABASE_URL, Prisma pooling/keep-alive settings, environment variables, Nginx/Apache TLS configuration, certificates, cipher suites and upstream/request timeouts. After each change, I’ll restart services and validate connections under realistic traffic, checking logs for connection drops, timeout errors and startup delays. I’ll provide the updated configuration files, a concise before/after performance report, and verify clean connectivity on both iOS and Android. I’ll also flag any additional bottlenecks I identify that could improve latency or stability. Best Regards, Jitendra Sharma
$100 USD in 8 days
5.2
5.2

The main challenge is separating a genuine backend bottleneck from symptoms that appear as slow iOS/Android startup or dropped connections. Prisma pool limits, database keep-alive, TLS negotiation, and server timeouts can interact, so changing one setting without a baseline may simply move the failure elsewhere. I’ll keep the first pass focused on the configuration path: inspect DATABASE_URL and Prisma environment-variable usage for errors, compare pool and keep-alive settings with the staging workload, and check the web server’s TLS and timeout configuration. I’ll make targeted changes rather than applying generic tuning values, then restart the affected services and verify behavior after each change. If a mobile rebuild is needed to confirm connectivity, I’ll include that in the validation. I’ll use the available logs and staging environment to compare connection errors and response/startup behavior before and after the changes. The updated configuration or safe-to-share snippets will be committed or supplied without exposing credentials. I’ll also provide a concise report explaining what changed, why, and the observed performance delta; if the available measurements don’t establish a reliable delta, I’ll state that clearly rather than overclaiming. Validation will cover clean connections from both iOS and Android builds and note any new warnings or errors. I’ll flag any separate stability issue uncovered during the pass instead of changing unrelated behavior without agreement. What database engine and hosting/runtime are behind the current Prisma connection so I can check the pool settings against the actual connection limits?
$120 USD in 5 days
4.8
4.8

Random disconnects plus slow app launch often come from production connection settings being slightly off, especially with Prisma pools, env variable mismatches, or server timeout/TLS combinations that look fine until traffic hits. I’d go through those layers methodically, apply the config updates, then verify stability with restarts and connection checks on both platforms. This is the sort of performance/stability work where details matter more than broad rewrites. I’ve helped fix issues caused by mis-typed env keys, weak keep-alive settings, certificate chain problems, and timeout values that cut requests too early, then packaged the findings into a clean handoff summary so the team knows exactly what changed and why. Your deliverables are clear, which makes this straightforward to execute. - Is the backend Node-based with Prisma directly, or is there another service layer in front of it? - Do you want the updated snippets committed in-repo, or supplied separately first for review? - Are the connection drops visible in backend logs already, or mainly being observed from the app side?
$155 USD in 4 days
5.0
5.0

I’m an experienced full-stack developer skilled in Node.js, Prisma, databases, and production configuration. My approach: - Optimize Prisma pooling, DATABASE\_URL, TLS, and server timeouts. - Fix connection drops and improve startup performance. - Restart and test services under load. - Verify both iOS and Android connectivity. Q: Can you share the staging logs and configuration so I can review the issue? Regards
$80 USD in 9 days
4.8
4.8

The pattern you described points to backend connection handling more than the Swift client itself: slow startup, intermittent drops, and a need to verify restarts after each tweak. I’d review the env and Prisma settings first, then move into TLS, cipher, and timeout checks so the fixes improve both speed and connection reliability rather than just masking the issue. I’ve worked on similar cleanup jobs where a few small production config mistakes caused outsized performance issues, especially around pooled DB connections, keep-alive behavior, and reverse-proxy timeout settings. I also like that you want the final result documented, because for this kind of work the report matters almost as much as the config changes. A quick extra pass for obvious millisecond-saving opportunities can be included while I’m in the stack. - Which database are you using, and is Prisma deployed in a containerized setup or directly on the server? - Will staging include the current nginx/apache and certificate setup, or are some TLS settings only present in production?
$168 USD in 4 days
4.6
4.6

Slow startup times and dropped connections on a cross-platform mobile app almost always trace back to backend configuration, so I would focus there and leave your Swift iOS build and Android client untouched. I would audit DATABASE_URL and your Prisma datasource settings, checking pool size, keep-alive, and mis-typed env values against your production traffic, then correct the TLS setup including certificate chain, cipher suites, and server timeouts so every request completes quickly and securely. I would stage every change first, restart the services, and confirm both builds connect with no new warnings before rolling out to production, then deliver the updated configs plus a report on the changes and the measured performance delta. I have tuned production Node.js backends on Prisma with connection pooling for mobile traffic, including a B2B platform where a misconfigured pool produced the same connection-drop pattern you are describing. Which database engine and hosting environment does the backend run on? And is TLS terminated at nginx, Apache, or the application layer itself? Share repository and staging access and I can start with the connection-pool audit right away.
$135 USD in 3 days
4.2
4.2

PROPOSAL I’ve gone through the backend performance issue carefully, and the right approach here is to diagnose the production configuration first rather than make broad changes that could introduce instability for the iOS and Android clients. I can audit the Prisma connection settings, DATABASE_URL/environment variables, pool sizing, keep-alive behavior, TLS configuration and server timeouts against the staging environment and current logs. I’ll apply changes incrementally, restart the relevant services after each configuration pass, and verify the API connections from both mobile platforms. You’ll receive the updated configuration snippets/files along with a concise report explaining each change and the observed performance/stability difference. If the logs reveal another backend bottleneck contributing to startup or connection drops, I’ll flag it separately before expanding the scope. Share the repository, staging access and current logs, and I can start with a configuration and connection-health audit.
$140 USD in 5 days
4.4
4.4

IF YOU ARE NOT HAPPY YOU DON'T PAY! Sporadic drops plus slow first requests often come from two timeout mismatches. Node's default 5s keepAliveTimeout can be shorter than nginx's upstream keepalive, so nginx reuses sockets Node already closed. And Prisma's pool can hold idle connections that the database or a load balancer has quietly killed. I'd tune connection_limit and pool_timeout in DATABASE_URL, check the cert chain (a missing intermediate often breaks Android while iOS still connects) and line up the nginx timeouts. You'd get the config diffs back with a before/after report. Is Postgres behind PgBouncer or a managed proxy? Send me a message and I'll explain exactly how I'd approach your project.
$250 USD in 3 days
3.3
3.3

GUANGZHOU, China
Payment method verified
Member since Jul 1, 2025
$250-750 USD
$250-750 USD
$30-250 USD
$250-750 USD
$250-750 USD
₹12500-37500 INR
$15-25 USD / hour
₹37500-75000 INR
$30-250 USD
$15-25 USD / hour
₹12500-37500 INR
$250-750 USD
₹1500-12500 INR
₹600-1500 INR
$750-1500 USD
₹12500-37500 INR
₹750-1250 INR / hour
$250-750 USD
₹12500-37500 INR
$30-250 USD
₹600-1500 INR
$10-30 USD
₹600-1500 INR
£250-750 GBP
₹1500-12500 INR