Re: [firebird-support] loading data from a .csv file?

2014-05-23 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Den 2014-05-18 21:23 skrev Alan Shank li...@notoriousshankbrothers.com [firebird-support] såhär: > > Is there some way to load data into a table in Firebird, like "LOAD DATA > INFILE..." in Mysql? I have comma-delimited files from Mysql that I want > to load into Firebird tables. > > I have Firebi

Re: [firebird-support] Simultaneous inserts / selects

2014-10-09 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Doychin Bondzhev doyc...@dsoft-bg.com [firebird-support] skrev: > On 3.10.2014 ã. 12:00 ÷., brucedickin...@wp.pl [firebird-support] wrote: >> do you have any experience in selecting from / inserting to table from >> multiple threads? Is it faster in comparision to one thread which >> selects / inse

Re: [firebird-support] Backups and the Delta File

2014-10-14 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
russ...@smxi.com [firebird-support] skrev: We have a large database that runs a full nbackup every night and an hourly incremental backup. Is the full backup meant to clear the delta file? this doesn't seem to get any smaller. Also if I restore a gbak backup, what should I do with the delta fi

[firebird-support] Performance diff between insert...select and for select ... do?

2015-02-13 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Hi, I'm writing a utility that will need to do two things for each record in an external table and for this purpose I use a for select ... do construct in an execute block. I do it this way because external tables can't be indexed and I will scan the entire external table anyway. The two opera

Re: [firebird-support] Performance diff between insert...select and for select ... do?

2015-02-15 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Mark Rotteveel m...@lawinegevaar.nl [firebird-support] skrev: > > On 13-2-2015 14:55, Kjell Rilbe kjell.ri...@datadia.se > [firebird-support] wrote: > > I'm writing a utility that will need to do two things for each record in > > an external table and for this purpose

Re: [firebird-support] Extract week of the year (within year)

2015-03-24 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
=?utf-8?B?U3ZlaW4gRXJsaW5nIFR5c3bDpnI=?= svein.erling.tysv...@kreftregisteret.no [firebird-support] skrev: > > >is possible to get week of the year "within year"? > > >I see that built in functions only support ISO-8601 (or i do not know > some parameter) > > Actually, Karol, “week within year” i

Re: [firebird-support] Performance diff between insert...select and for select ... do?

2015-04-13 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Kjell Rilbe kjell.ri...@datadia.se [firebird-support] skrev: > > Hi, > > I'm writing a utility that will need to do two things for each record in > an external table and for this purpose I use a for select ... do > construct in an execute block. I do it this way because ext

Re: Odp: [firebird-support] Performance diff between insert...select and for select ... do?

2015-04-14 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?=' liviusliv...@poczta.onet.pl [firebird-support] skrev: > > Why not merge? > Yes, indeed. Might have been worth a shot, but I suspect it would have been no more than marginally better. Even merge does have to do an index lookup for each record to

Re: Odp: [firebird-support] Performance diff between insert...select and for select ... do?

2015-04-14 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
'=?utf-8?B?bGl2aXVzbGl2aXVzQHBvY3p0YS5vbmV0LnBs?=' liviusliv...@poczta.onet.pl [firebird-support] skrev: > > Why not merge? Yes, indeed. Might have been worth a shot, but I suspect it would have been no more than marginally better. Even merge does have to do an index lookup for each record to c

[firebird-support] Charset of external table filename?

2015-09-24 Thread Kjell Rilbe kjell.ri...@datadia.se [firebird-support]
Hi, I'm trying to create an external table to import a list of id numbers like this: create table "ExLöpnr" external file 'D:\Löpnr.txt' ( "Löpnr" char(7) character set win1252, "CRLF" char(2) character set win1252 ); But when I try to select from it, Firebird creates a new empty file na