Hi Fellas,
I have a simple question: I need to save a lot of parsed lines from a
text file, with "INSERT" or "UPDATE" instructions, to put in a Firebird
Database, inside several tables.
Due to process reasons, I need to collect all those lines in something
like a "local temporary table" (not in memory table). Something like
"TClientDataSet", but not using lot of memory. Using TClientDataset as
memory table, i get "Out of Memory" errors...
Are there some solution inside FireDAC to do this? (i can not use SQLite)...
Regards
Pablo Romero
> {quote:title=Pablo Romero Romero wrote:}{quote}
> Hi Fellas,
>
> I have a simple question: I need to save a lot of parsed lines from a
> text file, with "INSERT" or "UPDATE" instructions, to put in a Firebird
> Database, inside several tables.
>
> Due to process reasons, I need to collect all those lines in something
> like a "local temporary table" (not in memory table). Something like
> "TClientDataSet", but not using lot of memory. Using TClientDataset as
> memory table, i get "Out of Memory" errors...
>
> Are there some solution inside FireDAC to do this? (i can not use SQLite)...
>
> Regards
>
> Pablo Romero
http://www.firebirdsql.org/refdocs/langrefupd21-ddl-table.html
--
Linden
"Mango" was Cool but "Wasabi" was Hotter but remember it's all in the "source"
Thank you for your Reply...
I have 70 Tables and for every table, between 20000 and 72000 records...
It's impossible to use something like "memory".
I would like to use SQLite but I'm not allowed to do so...
It's a process to "export" data from one Firebird database and "import"
all data in another FB database in a business branch...
My "Export process" generates something similar to MySQL dump backup in
one single text file.
My "Import" process reads this file and proceed to syncronize. This
process does not affect all tables on destination database.
That's why I need to read that file into "something" that does not use
so much memory and be even faster than TClientDataset.
Regards...
El 12/01/2015 05:32 p.m., quinn wildman escribió:
> Try TFDMemTable.
>
> How many rows of data do you have?
>
> Pablo Romero Romero wrote:
>> Hi Fellas,
>>
>> I have a simple question: I need to save a lot of parsed lines from a
>> text file, with "INSERT" or "UPDATE" instructions, to put in a Firebird
>> Database, inside several tables.
>>
>> Due to process reasons, I need to collect all those lines in something
>> like a "local temporary table" (not in memory table). Something like
>> "TClientDataSet", but not using lot of memory. Using TClientDataset as
>> memory table, i get "Out of Memory" errors...
>>
>> Are there some solution inside FireDAC to do this? (i can not use SQLite)...
>>
>> Regards
>>
>> Pablo Romero
>>
Thank you for your Reply...
I have 70 Tables and for every table, between 20000 and 72000 records...
It's impossible to use something like "memory".
I would like to use SQLite but I'm not allowed to do so...
It's a process to "export" data from one Firebird database and "import"
all data in another FB database in a business branch...
My "Export process" generates something similar to MySQL dump backup in
one single text file.
My "Import" process reads this file and proceed to syncronize. This
process does not affect all tables on destination database.
That's why I need to read that file into "something" that does not use
so much memory and be even faster than TClientDataset.
Regards...
El 12/01/2015 05:32 p.m., quinn wildman escribió:
> Try TFDMemTable.
>
> How many rows of data do you have?
>
> Pablo Romero Romero wrote:
>> Hi Fellas,
>>
>> I have a simple question: I need to save a lot of parsed lines from a
>> text file, with "INSERT" or "UPDATE" instructions, to put in a Firebird
>> Database, inside several tables.
>>
>> Due to process reasons, I need to collect all those lines in something
>> like a "local temporary table" (not in memory table). Something like
>> "TClientDataSet", but not using lot of memory. Using TClientDataset as
>> memory table, i get "Out of Memory" errors...
>>
>> Are there some solution inside FireDAC to do this? (i can not use SQLite)...
>>
>> Regards
>>
>> Pablo Romero
>>
Try TFDMemTable.
How many rows of data do you have?
Pablo Romero Romero wrote:
> Hi Fellas,
>
> I have a simple question: I need to save a lot of parsed lines from a
> text file, with "INSERT" or "UPDATE" instructions, to put in a Firebird
> Database, inside several tables.
>
> Due to process reasons, I need to collect all those lines in something
> like a "local temporary table" (not in memory table). Something like
> "TClientDataSet", but not using lot of memory. Using TClientDataset as
> memory table, i get "Out of Memory" errors...
>
> Are there some solution inside FireDAC to do this? (i can not use SQLite)...
>
> Regards
>
> Pablo Romero
>