Hello,

Why is the speed of every query so slow? I have connect a fast MySQL database to Outsystems, but when I run queries through Outsystems it loads very slow. I have a very small table with something like 2 rows but still takes about 2 seconds to load. What is the problem? How do I solve it?

Hi Jonathan Thunberg,

Details you have provided is not sufficient and your query is generic.

Usually query performance nothing to do with OutSystems please check any issues from database side.

Always use column names rather than * while querying from database. 


Sravan

Sravan Vanteru wrote:

Hi Jonathan Thunberg,

Details you have provided is not sufficient and your query is generic.

Usually query performance nothing to do with OutSystems please check any issues from database side.

Always use column names rather than * while querying from database. 


Sravan


I am a former PHP developer so I tried the database connection with a simple PHP script and had no problem, fast and stable connection. But when I use the same database connection through Outsystems as an "Aggregate" it is very slow.