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

"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

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

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
>

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
>
>

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

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
>

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.

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
>

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
>