| Subject | RE: [firebird-support] Database file size |
|---|---|
| Author | mahendra.nepali@iflexsolutions.com |
| Post date | 2006-04-26T03:58:37Z |
There are some businesses rules that I have apply why loading data.
Theto schema of the xml files is highly normalized to reduce the xml
file size. Hence I load all the data into temporary tables via external
tables. These temporary tables are generic or thin tables, that all the
data that are present in the xml file i.e. for every element I store the
records. Then I move the records from these temp tables into the main
area applying the business rules in the procedures. I cannot go to the
low level design of the application here whose performance right now is
not much of an issue.
My primary question was
As said that Firebird will utilize the deleted (unused) space for
storing other data. But please correct me, is this table specific or is
it database specific. I mean does Firebird utilize the deleted disk
space of one table, for inserts or updates into another table. To
elaborate this consider the following process
1) Delete from table A -> this deletes say 40 MB of data. Hence I have
40MB of unused space.
2) Some Inserts into Table B -> this inserts 20 MB of data but into
Table B. Will this utilize 20MB of the unused 40 MB?
Please let me know this.
Regards,
Mahendra Nepali
Desk: +91-22-67184586
Mobile: +919820191887
Email: mahendra.nepali@...
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Tuesday, April 25, 2006 10:18 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database file size
Importance: Low
mahendra.nepali@... wrote:
calculation, it approximately triples the amount of work done.
First you store the records. Then you store the records again.
Then you delete the records in the temp table. Why?
Regards,
Ann
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.
Theto schema of the xml files is highly normalized to reduce the xml
file size. Hence I load all the data into temporary tables via external
tables. These temporary tables are generic or thin tables, that all the
data that are present in the xml file i.e. for every element I store the
records. Then I move the records from these temp tables into the main
area applying the business rules in the procedures. I cannot go to the
low level design of the application here whose performance right now is
not much of an issue.
My primary question was
As said that Firebird will utilize the deleted (unused) space for
storing other data. But please correct me, is this table specific or is
it database specific. I mean does Firebird utilize the deleted disk
space of one table, for inserts or updates into another table. To
elaborate this consider the following process
1) Delete from table A -> this deletes say 40 MB of data. Hence I have
40MB of unused space.
2) Some Inserts into Table B -> this inserts 20 MB of data but into
Table B. Will this utilize 20MB of the unused 40 MB?
Please let me know this.
Regards,
Mahendra Nepali
Desk: +91-22-67184586
Mobile: +919820191887
Email: mahendra.nepali@...
-----Original Message-----
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Ann W. Harrison
Sent: Tuesday, April 25, 2006 10:18 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Database file size
Importance: Low
mahendra.nepali@... wrote:
>In what sense does that speed up the load process? From my rough
> To speed up the process I load lots of data into temp tables and then
> delete the records from them for each xml file I load.
calculation, it approximately triples the amount of work done.
First you store the records. Then you store the records again.
Then you delete the records in the temp table. Why?
Regards,
Ann
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://firebird.sourceforge.net and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links
DISCLAIMER:
This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version.