Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 11 to 19 of 19 total |
C/S performance |
Thu, Oct 10 2013 3:17 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Thu, Oct 10 2013 8:04 PM | Permanent Link |
Arthur Williams Zarksoft | 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 |
Wed, Oct 16 2013 3:11 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@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 |
Mon, Oct 21 2013 8:51 AM | Permanent Link |
Dominique Willems | 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. |
Tue, Oct 22 2013 1:36 PM | Permanent Link |
Arthur Williams Zarksoft | 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. |
Wed, Oct 23 2013 2:55 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Arthur
If its possible can you post your test code to the binaries. Roy Lambert |
Wed, Oct 23 2013 10:15 AM | Permanent Link |
Dominique Willems | 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> |
Thu, Oct 24 2013 5:13 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
Fri, Oct 25 2013 4:57 PM | Permanent Link |
Terry Swiers | 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 --------------------------------------- |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Sunday, May 19, 2024 at 08:46 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |