I have a huge table to import - tens millions of rows.
From my experience, it is not good practice to commit job after importing
everything, because import of rows can become slower and
slower.
So, i decided to make commit after every 50.000 rows. So far so good.
There is no reason to not
For iLoop as Integer=0 to grid.Rows.Count-1'Grid Has 100,000 Rows
'-Sometimes Hang Here Also-
rdr = Get_Reader(USP_CHECK_AND_GET_ITEM_EXIST('
Mid(Trim(dicFields_Name.Item(SP_ITEM_CODES)), 1, 20) ','
Mid(Trim(dicFields_Name.Item(ITEM_PART_CODES)), 1, 20) ','
Hi,
There is a fix in 254 snapshot for similar problem.
Download fresh 2.5.4 Firebird snapshot and try it.
Regards,
Alexey Kovyazin
IBSurgeon
Firebird Recovery service:
http://ib-aid.com/en/firebird-interbase-recovery-service/
Database Performance optimization:
Following Code/Process I am Using
Private Function Process_Grid_Data() As BooleanDim rdr As FbDataReaderDim
dicStoredProc As New Dictionary(Of String, String)Dim fbTrans As FbTransaction
= NothingDim strErrorMsg as String=Dim Is_Update as Boolean=FalseDim
nITEM_IDS As Long = 0Dim nGroup_IDS As
Hi Group,
I have a huge table to import - tens millions of rows.
From my experience, it is not good practice to commit job after importing
everything, because import of rows can become slower and slower.
So, i decided to make commit after every 50.000 rows. So far so good.
Now I am at
Aleksey,
What I did is:
Stopped firebird 2.5.3 server
Renamed bin folder to bin orig
copied BIN folder from zip file I downloaded (snapshot 2.5.4)
started firebird server
Checked server vesrion - it says 2.5.4.26842
Continuing import after 72.000.000 rows, now I get folowing timings:
100.000
unit_id is primary key and this table(m_unit ) has hardly 20 records
On Tuesday, February 24, 2015 3:43 PM, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com wrote:
Select first(1) u.UNIT_ID from m_unit u
where
Hi Aleksey,
Thanks for the reply.
Should I just uninstall, install other version, or I should aslo do backup /
restore ?
regards,
Zoran
On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]
firebird-support@yahoogroups.com wrote:
Sukhen wrote:
update never fails but it fails in insert query. loop run in a single
connection with a new datarows in same query.
I
On Feb 23, 2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com
[firebird-support] firebird-support@yahoogroups.com wrote:
I am using vb.net which has a grid of 100,000 records and 30 columns have to
insert in a firebird table.
First, you've hijacked a thread, which is not considered
Hi all
Learning from one of the replies from Set on my other thread I tried to replace
my SP with an improved one. One that would return two results (date range) in
one row instead of two calls to the older SP.
I can't use CTEs in the Remote Views where the final query is used, so that is
Hi,
1. Is this VB exe or web?
2. Save all insert statement parameters to tabbed csv and you will see at what
statment it stop. If this is always at the same statement, then compare it e.g.
in excel withprevious statements.
Regards,
Karol Bieniaszewski
- Reply message -
Od: SUKHEN
its not always at same insert statementhang insert statement varies
On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS
sukhend...@yahoo.com wrote:
its a window base app using vb.net... i will definitely try your suggestion
On Wednesday, February 25, 2015 11:48 AM,
Actually an index on tSupport.tDt I think made both the queries slower
its a window base app using vb.net... i will definitely try your suggestion
On Wednesday, February 25, 2015 11:48 AM, 'liviusliv...@poczta.onet.pl'
liviusliv...@poczta.onet.pl [firebird-support]
firebird-support@yahoogroups.com wrote:
Hi,
1. Is this VB exe or web?
2. Save all
Hi, I need some help to convert DB 1.5 to 2.5. I've used gbak 1.5 for backup
and gbak 2.5 for restore operations but I've got error messages. It is a small
sample file, so I would like to attach fdb and fbk files for verification, but
I don't see UPLOAD options anywhere. Thanks for your help.
At 02:54 p.m. 25/02/2015, you wrote:
Hi, I need some help to convert DB 1.5 to 2.5. I've used gbak 1.5 for backup
and gbak 2.5 for restore operations but I've got error messages. It is a small
sample file, so I would like to attach fdb and fbk files for verification,
but I don't see UPLOAD
19 matches
Mail list logo