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

2014-05-24 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

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Hannes Streicher hstreic...@gmx.de [firebird-support]
Guten Tag halim1...@yahoo.com [firebird-support], much too few information for any reasonable answer, so just the standart Cache settings ? ar way too low in staddart classic setup try increasing them Hello All, Our database is about 30 GB. We are using Firebird 1.5. When restoring the

[firebird-support] search table by array value using parameters

2014-05-24 Thread Arthur arthur.sile...@gmail.com [firebird-support]
//In firebird example database employee is table 'job' //with string[] column 'language_req' // i have some code: fbcmd.CommandText = select language_req from job where job_code=SRep; fbreader = fbcmd.ExecuteReader (); Array array_value; if (fbreader.Read ()) array_value =

RE: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Thank you for your reply. I used default restore settings and I got over 8 hours of restore time. Increasing the cache size using gfix -b did not help at all. I got the same result. I don't think it helps during the restore process.-Halim To: firebird-support@yahoogroups.com From:

Re: [firebird-support] Restore DB with Firebird 1.5 Super Server vs Classic Server

2014-05-24 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi, In order to give you a good optimization advice, please answer the following questions: http://ib-aid.com/en/articles/required-information-for-firebird-database-performance-optimization/ Regards, Alexey Kovyazin IBSurgeon Thank you for your reply. I used default restore settings and I