Search the Community
Showing results for tags 'tfdmemtable'.
Found 3 results
Hi, I usually use varchar fields in SQL databases with a big number as max size. When I use a TFDMemTable, does the ftstring size consumes memory as described in its definition? If I declare it as "Add('lab',ftstring,500)", does it consumes in memory 500bytes (or 1000bytes) for each record, or as a Delphi string type is just the content string size ? I have Delphi professional and I can not see its code. Thank you in advance
I have to update an application that has 20 threads running at the same time and each thread is requesting an XML through an http connection. In order to process the received XML, each thread has to use data from 14 TFDMemtables. The Threads are the same running all the time and the TFDMemtables they use are also the same, The TFDMemTables' data are static, received from an external database when application starts, not need to be updated/edited as the application runs. I read that with TFDMemTable you can use clonecursor and have different TFDMemTable object instances with the same data. I though that I could create such a TFDMemTable for each thread before threads start to use them. My question: Can different threads use TFDMemTables object instances (created with data from clonecursor) from an initial TFDMemTable? Is this threadsafe? Thank you in advace
Sqlite give the possibility to create two different ':memory:' databases and attach tables from the one database to the other. Using firedac with a ':memory:' sqlite database, is it possible to attach TFDmemtables as sqlite (virtual) tables? If so, how? Thank you in advance