|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stay one step ahead of the competition. Evaluate and give feedback
on some of the hottest web development tools on the market today.
Make your opinion heard! Click
Here
|
|
#1
April 11th, 2008, 06:40 AM
|
|||
|
|||
|
External Table File Format
Hi
I've searched Google for a couple of days trying to find the format of an external table. I use Delphi with the UIB components and need to create an external file to be imported into Firebird. I have a program that needs to add upwards of 100,000 records everytime it runs. It works OK with insert statements and commits every 1000 records but I would like to speed it up if possible. Thanks Taoh
|
|
#2
April 11th, 2008, 08:33 AM
|
||||
|
||||
|
Quote:
Searching this forum is also good, see here and here
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
#3
April 11th, 2008, 08:58 AM
|
|||
|
|||
|
Hi
By two days I meant searching AND TRYING solutions without success and I couldn't figure out how to search just this forum. - I have now. I have managed to do what is required using external tools, but they use a binary format which I can't figure out. I am trying to create a set of data outside FB then import it. Cheers Taoh
|
|
| Viewing: Dev Shed Forums > Databases > Firebird SQL Development > External Table File Format |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
