Good day everybody!

 

Could you tell me please if it is normal that memory used by application
goes like this:

SQLite3_Prepare_v2 - Memory used changes slightly

Binding values - Memory used changes slightly

Loop with sq3lite_step - Memory used growths by 16Mb

sq3lite_finalize - Memory used doesn't reduce

 

SQL: SELECT * FROM tb WHERE datetime>":.." and datetime <":.."

SQL result: aprox. 71000 records

 

Table CREATE Syntax:

CREATE TABLE tb

(DataSource STRING, datetime TEXT, Open REAL, High REAL, Low REAL, Close
REAL, Volume Integer, FileName STRING, QUIK_DT TEXT)

 

Thank you!

 

 

Best regards,

Alexander.

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to