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 70.000.00
>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,
table & stored procedure structureCREATE TABLE M_ITEM( ITEM_IDS Integer NOT
NULL, SP_ITEM_CODES Varchar(20), Its a column not stored procedure,in
front end we check if any columns starts with SP_ then code to be generated
using sp ITEM_NAMES Varchar(50), RATE Decimal(10,2),bla,bla), CON
> Select first(1) u.UNIT_ID from m_unit u
>where (upper(trim(u.UNIT_NAME))= upper(trim(:MAIN_UNIT))
>or upper(trim(u.UNIT_SYMBOL))=upper(trim(:MAIN_UNIT)))
> and coalesce(CONVERSION_UNIT_ID,0)=0 Into :Main_Unit_Id;
Does this select use any index at all? How many records are t
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:
http://ib-aid.com/en/firebird-inte
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]"
wrote:
> Select first(1) u.UNIT_ID from m_unit u
> where (upper(trim(u.UNIT_NAME))= up
Hi Aleksey,
Thanks for the reply.
Should I just uninstall, install other version, or I should aslo do backup /
restore ?
regards,
Zoran
Hi,
In general yes, it's better to do backup/restore, but for this
particular bug fix you don't need backup and restore.
Regards,
Alexey Kovyazin
IBSurgeon
Hi Aleksey,
Thanks for the reply.
Should I just uninstall, install other version, or I should aslo do
backup / restore ?
regards,
On Feb 23, 2015, at 1:06 AM, SUKHEN DASS sukhend...@yahoo.com
[firebird-support] 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 polite on this very
traditional e
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 i
> On Feb 24, 2015, at 3:29 AM, Svein Erling Tysvær
> svein.erling.tysv...@kreftregisteret.no [firebird-support]
> 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 answered:
>>> Could
thanks as you suggested i have check with all the possibilities but never got
suceess.Let me tell you more what i have tried before post.1.Regular way as
i have mentioned in the thread.2.Commenting out the update, only run insert
still hang in Insert Statement.3.Commenting out the procedure
> 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
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 UPLOA
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 DA
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
the
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]"
wrote:
Hi,
1. Is this VB exe or web?
2. Save all insert statement parameters to
its not always at same insert statementhang insert statement varies
On Wednesday, February 25, 2015 12:27 PM, SUKHEN DASS
wrote:
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
23 matches
Mail list logo