On 9.10.2014 ã. 14:32 ÷., brucedickin...@wp.pl [firebird-support] wrote:
Thank you guys for your input! I appreciate it!
I have some doubts.. isn't TCP/IP a bottleneck here? I mean, I am
sending for example 4 times (4 threads) more data to insert via network.
@Doychin I do have like 2-3
I'm joining this late and may have some of the details incorrect. But
doesn't your client tool have a batch insert object? If your client is
written in either Delphi or .NET, I'm pretty sure it does and that would be
the best way to insert bulk records.
Dixon
On Thu, Oct 9, 2014 at 8:18 AM,
I ran the following script in FlameRobin. Database is on a virtual machine in
the cloud.
When I checked results after running the script, also checked them in
FlameRobin, all the changes had taken place EXCEPT TBLTESTER.TESTERLOGIN. It
was still the old size.
The script ran without
On 9-10-2014 10:22, 'Tiberiu Horvath' tiberiu_horv...@yahoo.com
[firebird-support] wrote:
Hi all,
I have the following table :
CREATE TABLE LOG_TABLE (
ID_LOG_TABLE INTEGER NOT NULL,
SESSION_ID INTEGER,
LOG_DATA DATE,
LOG_TIME TIME,
LOG_TEXT VARCHAR(100),
On 9-10-2014 14:57, 'E. D. Epperson Jr' dixonepper...@gmail.com
[firebird-support] wrote:
I'm joining this late and may have some of the details incorrect. But
doesn't your client tool have a batch insert object? If your client is
written in either Delphi or .NET, I'm pretty sure it does and
I was referring to SqlBulkCopy which is part of the System.Data.SqlClient in
C#. I used that a couple of years back, but granted it was with MsSql.
However, I thought I remembered having a similar tool to that back in the
Delphi 7 days, I just don't remember if I used it with Firebird or
Mark,
I am not sure how gbak reads blobs, but if it honours the defined segment
size,
IIRC, Ann has mentioned that SEGMENT SIZE is a legacy issue that hasn't really
been used in some time.
Our application uses BLOB fairly extensively and can report that the GBAK disk
write rate increases
LSSBcfs Our application uses BLOB fairly extensively and can report
LSSBcfs that the GBAK disk write rate increases very significantly
LSSBcfs when tables with Blobs are being backed-up, orders of
LSSBcfs magnitude faster than tables with small rows (YMMV), so this
LSSBcfs suggests that SEGMENT
@Dixon It is never to late to join conversation;) Thanks for your suggestions,
I've found some interesting methods in my client's library.
@Doychin: I am using Delphi and FIBPlus. I am not sure if we mean the same
thing by batch script. Some guys at my company prefer to generate a long
script