Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM Client/Server » View Thread |
Messages 1 to 10 of 21 total |
DBISAM / Delphi application extremely slow |
Fri, May 11 2007 9:37 AM | Permanent Link |
"Tom Szabo" | Hi,
Our client purchased an application that is written in Delphi and uses DBISAM. The Database server runs on a MS 2003 SmallBusiness Server Premium. The hardware is Dual Xeon 3.2GHz, 2M Cache, 4gig ram, 2 x 15K Rpm SCSI HDD in mirror n RaidController with 128 cache.... To eliminate the possibility of hardare problem, we have replaced the complete server bbut no change. The application runs very slow, inserting a record can take up to 10 seconds. I am not sure how the software was written but I suspect the vendor would not have any copies sold if tthis would be the usual performance and I can't imagine much better hardware to run this thing. I have removed the AVirus software, that did not make any differenc either... The vendor has no clue. Does anyone have any clues what could it be????? TIA, Tom |
Fri, May 11 2007 10:29 AM | Permanent Link |
"Robert" | "Tom Szabo" <tom@intersoft.net.au> wrote in message news:C2513238-388B-4827-87D8-255E2F063A91@news.elevatesoft.com... > Hi, > > Our client purchased an application that is written in Delphi and uses Hard to tell, obviously. I would download the utilities from www.elevatesoft.com (free download) and experiment a bit with DBSYS, so that you at least can tell if the problem is with the client side of the app, or with the server. Robert |
Fri, May 11 2007 3:31 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Tom,
<< To eliminate the possibility of hardare problem, we have replaced the complete server bbut no change. The application runs very slow, inserting a record can take up to 10 seconds. I am not sure how the software was written but I suspect the vendor would not have any copies sold if tthis would be the usual performance and I can't imagine much better hardware to run this thing. >> It is very difficult to examine these types of issues from the "outside". If you could have the vendor contact us directly, then we can discuss what issues there may be with the way the application was coded, etc. Until we know exactly what the vendor is doing when you say "inserting a record", we're really just guessing. -- Tim Young Elevate Software www.elevatesoft.com |
Fri, May 11 2007 11:21 PM | Permanent Link |
"Tom Szabo" | Hi Tim,
Thanks for the quick reply. I should have mentioned that the problemis not just with inserting record. The system is generally slow when accessing data. Logging in, into the ( database ) system can take up to 10-15 seconds after the password is entered. The most apparent when the user adds a component to the job, this is what I meant by inserting a record. I am not sure if this makes things any clearer or not, but the situation is the same even if you log into the server as a terminal server session and use the software from the server itself. There is no improvement in any respect. As such I suspect something is timing out or has a conflict, but no idea what. In the programs ini file it had the server 's name "SBSERVER", I thought it may be a name resolution, so changed it to the IP address, still no difference. I have done the testing on the "training" database, which has few record only, still the same. As I mentioned I disabled the AVG antivirus software completely, all services disabled, restarted the server, still no change. Just thought it may worth mentioning, it is written in Delphi 7 Pro and uses DBISAM 3.27... I have also contacted the Vedor and they will get in touch with you people, but this will only happen after Monday as their tech guy is away at the moment. In the mean time if you have any reasonable guesses, I am happy to try, Regards, Tom "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:F705675D-EF60-4723-97A2-5C276A83DC76@news.elevatesoft.com... > Tom, > > << To eliminate the possibility of hardare problem, we have replaced the > complete server bbut no change. The application runs very slow, inserting > a record can take up to 10 seconds. I am not sure how the software was > written > but I suspect the vendor would not have any copies sold if tthis would be > the usual performance and I can't imagine much better hardware to run this > thing. >> > > It is very difficult to examine these types of issues from the "outside". > If you could have the vendor contact us directly, then we can discuss what > issues there may be with the way the application was coded, etc. Until we > know exactly what the vendor is doing when you say "inserting a record", > we're really just guessing. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Fri, May 11 2007 11:28 PM | Permanent Link |
"Tom Szabo" | Thanks Robert, will try...
Thanks again, Tom "Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote in message news:26B8372B-3F8E-4DC2-B5D1-5AFDC42C7E11@news.elevatesoft.com... > > "Tom Szabo" <tom@intersoft.net.au> wrote in message > news:C2513238-388B-4827-87D8-255E2F063A91@news.elevatesoft.com... >> Hi, >> >> Our client purchased an application that is written in Delphi and uses > > Hard to tell, obviously. I would download the utilities from > www.elevatesoft.com (free download) and experiment a bit with DBSYS, so > that you at least can tell if the problem is with the client side of the > app, or with the server. > > Robert > > |
Sat, May 12 2007 3:40 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Tom
What happens if you drop the server and the app onto the same machine, use the 127.0.0.0 address so there's no network interaction? Roy Lambert |
Mon, May 14 2007 9:41 AM | Permanent Link |
"Tom Szabo" | Thanks Roy,
Will try, sound like a good option to test, Thanks again, Tom "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:8C3B2854-5687-4909-8528-B35B90E3C26D@news.elevatesoft.com... > Tom > > > What happens if you drop the server and the app onto the same machine, use > the 127.0.0.0 address so there's no network interaction? > > Roy Lambert > |
Mon, May 14 2007 3:16 PM | Permanent Link |
Aage Johansen | Tom Szabo wrote:
> > I should have mentioned that the problemis not just with inserting record. > The system is generally slow when accessing data. Logging in, into the ( > database ) system can take up to 10-15 seconds after the password is > entered. ... Could it be mismatched network cards? Set the speed explicitly to the same value (e.g. 100MHz) on both adapters and see if it helps. The problem might be that the units are trying to agree on something, but fail. -- Aage J. |
Tue, Jun 12 2007 9:46 AM | Permanent Link |
"Tom Szabo" | Hi Tim,
I have tried to talk to the developer, but they not overly helpful, and as I can see not very efficient in troubleshooting either. They said that they did the test on the localhost, and the results were the same Anyway, what we have found is the software is (DBIsam most likely ) conflicting with some services on the SBS 2003 server. As I worked out, these guys have no clue what is a Small Business Server, they did some test on an Enterprise 2003, which is obviously not the same. After pushing them, we did a test together on the client's server live, and it appears that some services are conflicting.... ....... the important part is that IIS, ISA, SMTP, IPSec and some related services seem to make a lot of difference. If one stops these, the software speeds up 5-10 times easily Is anyone else using Windows 2003 SBS Premium with DBIsam?? Any similar experiences? Any help will be greatly appreciated, TIA, Tom "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:F705675D-EF60-4723-97A2-5C276A83DC76@news.elevatesoft.com... > Tom, > > << To eliminate the possibility of hardare problem, we have replaced the > complete server bbut no change. The application runs very slow, inserting > a record can take up to 10 seconds. I am not sure how the software was > written > but I suspect the vendor would not have any copies sold if tthis would be > the usual performance and I can't imagine much better hardware to run this > thing. >> > > It is very difficult to examine these types of issues from the "outside". > If you could have the vendor contact us directly, then we can discuss what > issues there may be with the way the application was coded, etc. Until we > know exactly what the vendor is doing when you say "inserting a record", > we're really just guessing. > > -- > Tim Young > Elevate Software > www.elevatesoft.com > |
Tue, Jun 12 2007 9:46 AM | Permanent Link |
"Tom Szabo" | Thanks Roy,
We did the test and it stays the same.... ....on the other hand if we start to shut down services like ISA, IIS, Kerberos, ans some related other services it speeds up 5-10 times The server is a dual xeon 3.2GHz 4GB Ram 15K Rpm drives, so certainly not overloaded for 5 users on the network Anyway, more clues will be appreciated TIA, Tom "Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:8C3B2854-5687-4909-8528-B35B90E3C26D@news.elevatesoft.com... > Tom > > > What happens if you drop the server and the app onto the same machine, use > the 127.0.0.0 address so there's no network interaction? > > Roy Lambert > |
Page 1 of 3 | Next Page » | |
Jump to Page: 1 2 3 |
This web page was last updated on Tuesday, September 17, 2024 at 04:19 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |