Skip to Content (Press Enter)
2020-10-30 00-51-44
EiMon WinAung
47Views
2Comments
Response from OutSystems to DB
Question

Hello 

       Anyone who knows how to deal with the Database performance ? 

I couldn`t find the document concerning with that .If you know , please tell me .



I am facing the time delay when outsystems connects to the external database(MySql).

   In  DB connection ,  100  goes up to 250.

    In Write IOPS,   200count/sec goes up to 700count/sec)


Thanks ahead..

1
0
20 Aug 2019
Copy Link
2021-02-02 11-55-27
Tushar Panpaliya

You can try optimizing the performance at the DB end by applying some indexes etc. But I don't think that'll help in this scenario. 


We had a similar instance with an external Db we were Connecting to. What worked for us was , we got a high speed connection created between the DB network and the OS AWS instance. The performance is almost realtime now. 


Cheers,

Tushar

2
0
20 Aug 2019
Copy Link
2020-10-30 00-51-44
EiMon WinAung

Tushar Panpaliya wrote:

You can try optimizing the performance at the DB end by applying some indexes etc. But I don't think that'll help in this scenario. 


We had a similar instance with an external Db we were Connecting to. What worked for us was , we got a high speed connection created between the DB network and the OS AWS instance. The performance is almost realtime now. 


Cheers,

Tushar

Hello Tushar Panpaliya

       First , let me say thank to you. 

      Would you provide some documentation about how you created the high speed connection  between them? 

      Or if you know some documentation that can solve this issue, please attach .

 

Thanks again ,

Ei Mon 


0
0
20 Aug 2019
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.