@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
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 SEGMEN
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 v
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 Sql.
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 a
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
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 er
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, Doy
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
At the same time really about 50-70 threads writing data. Some threads
reading data and some others writing.
One insert in one transaction(it's feature of my task, I can't do it in
another way).
Today server without 1GB interface - it's not server. But if you will
start application local it's al
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 indexes per table but the speed in single thread
was sufficient. Thanks, I hope
I have such experience. If you understand what you want and how to
create table that will be very fast all will be ok. But If you never
done something like this as the result you may create more slowly
multithreading application. For today I have one application that
without any problem in the
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
On 3.10.2014 ã. 12:00 ÷., brucedickin...@wp.pl [firebird-support] wrote:
> Hi,
>
> do you have any experience in selecting from / inserting to table from
> multiple threads? Is it faster in comparision to one thread which
> selects / inserts data in queue?
>
> What is your opinion on this? My gut t
Hi all,
I have the following table :
CREATE TABLE LOG_TABLE (
ID_LOG_TABLE INTEGER NOT NULL,
SESSION_IDINTEGER,
LOG_DATA DATE,
LOG_TIME TIME,
LOG_TEXT VARCHAR(100),
LOG_TEXT_COMPLET BLOB SUB_TYPE 1 SEGMENT SIZE 80
)
with some 300
15 matches
Mail list logo
