Hi, I suspect that what I am doing with Exposed (0...
# exposede
edwinRNDR
09/14/2021, 10:17 AMHi, I suspect that what I am doing with Exposed (0.31) is leaking memory and/or resources. Are there ways to disable all of Exposed's caching? What are tools to detect improper use of the Exposed DAO?
b
Bogdan
09/14/2021, 2:24 PMwhy do you think there is a leak? Can't see the code with DAO
Bogdan
09/14/2021, 2:25 PM Copy code
val user: Column<User> = ?????????????????????????👀 1
e
edwinRNDR
09/14/2021, 2:57 PMI think there is a leak because over time anything I do against the database is slow and my program uses a lot of memory. I am not saying this is an issue in Exposed per se. I am just looking for a way to disable caching to quickly eliminate it from the list of possible causes
b
Bogdan
09/14/2021, 4:09 PMwhat kind of caching? In your examples, there is no Entity exposed (only they are cached), therefore there is nothing to disable
e
edwinRNDR
09/14/2021, 4:09 PMI haven't posted any examples
b
Bogdan
09/14/2021, 4:10 PMmost likely you are doing a lot of transactions
e
edwinRNDR
09/14/2021, 4:10 PMyes, and?
b
Bogdan
09/14/2021, 4:11 PMI haven't posted any examplehow difficult. are you using Entity?
Bogdan
09/14/2021, 4:13 PMyes, and?read what a transaction is, they can block each other
Bogdan
09/14/2021, 4:13 PMMy English not so good
e
edwinRNDR
09/14/2021, 4:18 PMif transactions are in some way postponed and eventually pile up then I'd like to hear how to disable that.
b
Bogdan
09/14/2021, 5:11 PMtransactions impose restrictions on, for example, table entries. It is not possible in an RDBMS to write to one table from different threads (transactions)
https://en.wikipedia.org/wiki/Database_transaction
https://www.tutorialspoint.com/dbms/dbms_transaction.htm
Bogdan
09/14/2021, 5:12 PMthe transaction must be atomic
Bogdan
09/14/2021, 5:16 PMhttps://github.com/JetBrains/Exposed/wiki/DAO
This is where the cache is used (for Entity). If you use it, then you should look at an example where problems appear.
t
tapac
09/15/2021, 10:40 AM@edwinRNDR, there can be diferrent type of leaks: connection leak, prepared statement leak, resultset leak, etc, what kind of do you have?
Entity Cache is bound to transaction and memory should be free after the end of transaction block.
tapac
09/15/2021, 10:41 AMThe more details needed to help you, also try to update to the latest 0.34.2 version as there were few performance improvements
22 Views