Arthur,

<< I'm referring to the total network traffic going out over the nic. I
don't care what's going on, I was just doing some small testing of some of
the db software I have. I bought something like six db systems last year and
now I'm sorting through them to see which support subscriptions I plan to
renew and which ones I'm dropping, that's all.  >>

Okay, can you at least give me a clue - are you using SQL or navigational
inserts ?

<< I did already renew DBISAM. >>

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

   EDBQuery1.close;
   EDBQuery1.SQl.Clear;

   EDBQuery1.SQL.Add('INSERT INTO CODES(userno,useridx)');
   EDBQuery1.SQL.Add('VALUES(:userno,:useridx)');
   EDBQuery1.Prepare;

   for i  := 1 to  100000 do
   begin
     EDBQuery1.ParamByName('userno').AsInteger := 0;
     EDBQuery1.ParamByName('useridx').AsInteger := 0;
     EDBQuery1.ExecSQL;
   end;



Nothing complicated. There's a third field which is an identity, so it's not shown in the code. EDB performed just fine as far as I'm concerned. I was just a little surprised at how much less network traffic there was with IB. Normally my code wouldn't drive the db anything like that, so it's not an issue.



>>>
"Tim Young [Elevate Software]" wrote:

Arthur,

<< I'm referring to the total network traffic going out over the nic. I
don't care what's going on, I was just doing some small testing of some of
the db software I have. I bought something like six db systems last year and
now I'm sorting through them to see which support subscriptions I plan to
renew and which ones I'm dropping, that's all.  >>

Okay, can you at least give me a clue - are you using SQL or navigational
inserts ?

<< I did already renew DBISAM. >>

Thanks,

Tim Young
Elevate Software
www.elevatesoft.com

Arthur,

<< Nothing complicated. There's a third field which is an identity, so it's
not shown in the code. EDB performed just fine as far as I'm concerned. I
was just a little surprised at how much less network traffic there was with
IB. Normally my code wouldn't drive the db anything like that, so it's not
an issue. >>

Thanks very much.  There should only be one request/response per ExecSQL
call, so I'll have to do some more investigating to see what's "taking up
all of the space".

Tim Young
Elevate Software
www.elevatesoft.com

Roy Lambert wrote:
> > Wall time is the elapsed time based on the clock on the wall.
>
> Oh.

There is wrist and pocket time too. The same, really. Just slightly
warmer.

One striking difference is that EDB is far slower than DBISAM in creating tables and indexes. It's relative of course, EDB only takes maybe 5-10 seconds, but DBISAM is pretty much instantaneous.

Anyway, I've decided to stick with DBISAM and drop EDB. I rarely use SQL and DBISAM does the job well enough for now.  

Arthur


If its possible can you post your test code to the binaries.

Roy Lambert

Arthur Williams wrote:
> Anyway, I've decided to stick with DBISAM and drop EDB. I rarely use
> SQL and DBISAM does the job well enough for now.

I'm on EDB only for Unicode, and waiting for Tim to release DBISAM 5
with Unicode.

<gd&r>

Arthur,

<< One striking difference is that EDB is far slower than DBISAM in creating
tables and indexes. It's relative of course, EDB only takes maybe 5-10
seconds, but DBISAM is pretty much instantaneous. >>

This is the database catalog - it is designed to be fail-safe and has to
make a backup copy and do a hard flush to disk during any DDL, and it takes
this hit for each CREATE INDEX, etc.  One of the enhancement requests that's
been around for a while is to allow for DDL transactions to make sure that
the hit is only taken once at the end.

Tim Young
Elevate Software
www.elevatesoft.com

Hi Tim,

> There should only be one request/response per ExecSQL call, so I'll have
> to do some more investigating to see what's "taking up all of the space".
>

We have a couple of users who do a lot of work on the road using their phone
as the internet connection with our app in a C/S setup.  If there is "extra"
junk being sent back and forth that can be tracked down and eliminated, that
would be very beneficial for our users.

So just consider this a second request for a bit of time to look into this.


---------------------------------------
Terry Swiers
Millennium Software, Inc.
http://www.1000years.com
http://www.atrex.com
---------------------------------------