Looking for Some Best Practices for Optimizing Xojo Web App Performance?

General
1

Hello,

I am building a web application in Xojo and I am looking for some advice on optimizing its performance. My app involves dynamic content generation and interacts heavily with databases…, so keeping it responsive is crucial.

Here are a few specific areas I’d like insights on :-

Session Management :- What’s the best way to handle sessions efficiently in Xojo web apps: ?? Are there any pitfalls I should avoid: ??
Database Queries :- How can I optimize database interactions: ?? Is using prepared statements enough, or are there Xojo-specific best practices: ??
UI Responsiveness :- Any tips on minimizing lag when the app updates UI elements dynamically: ??
Scalability :- If the app grows and the number of users increases, what strategies can ensure it scales well: ??

I have already reviewed the Xojo documentation but would love to hear real world experiences and tips from the community here.

Thanks in advance for your help !!

Looking forward to your insights !!

With Regards,

DanielTableau

2

Welcome @Daniel_Jose

I don’t have a license for Xojo Web myself (I mostly do macOS Desktop apps), so I have very little to offer for web-related advice at the moment, beyond suggesting Prepared Statements - which you’ve already covered :+1:

So I think that means you’re new to Xojo, but not programming? That is awesome, because I hope you’ll find Xojo advanced language features very helpful.

Mainly I’m posting to say hello and to post a link to this page about web optimization in the documentation (or maybe you found it already?), and also to say that many of the Web folks here have a lot of good words to say about LifeBoat, a Xojo built web deployment tool, that is apparently, well, a life saver… :wink:

Have fun, and I hope you garner some helpful tips.