Mega Search
23.2 Million


Sign Up

Make a donation  
About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac

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

Vote for best question.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 10:30 AM EST
From: Pablo Romero Romero
 
Re: About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac
SQLite

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 10:44 PM EST
From: Franc Burdian
 
Re: About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac
> {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"

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 4:21 PM EST
From: Linden ROTH
 
Re: About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac
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
>>

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 1:13 PM EST
From: Pablo Romero Romero
 
Re: About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac
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
>>

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 1:12 PM EST
From: Pablo Romero Romero
 
Re: About local temporary tables.  
News Group: embarcadero.public.delphi.database.firedac
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
>

Vote for best answer.
Score: 0  # Vote:  0
Date Posted: 12-Jan-2015, at 12:32 PM EST
From: quinn wildman