Hello, I have a quick question, is it possible to ...
# squarelibrariesm
Maurice Jouvet
01/10/2020, 1:40 PMHello, I have a quick question, is it possible to create dynamic table with sqldelight?
Or maybe another solution to help with my potential issue.
I have to store in db, lots of records data with these information, three columns (id, value, parent_id) primary key: id, parent_id.
When I say lots of records, I’m talking about near 700 000 records. If I am using only one table.
If I am able to create dynamic table, I will be able to divide them regarding the parent_id. So I will have a Record12 with (id, value) and 12 is the parent_id. (Like Record1, Record2, Record3...)
RecordX will contains less data but will be able to have 50 000 records sometimes.
Do you think it’s possible, or an issue to use only one table, or should I chunk them? Is there another way to do that? I need to use a multiplatform solution. Thanks in advance.