"Uli Becker" <johnmuller54@googlemail.com> wrote in message

> Don't worry: there are only small changes in the application, but the
> benefits are great.
>
> Just setting some properties are enough:
>
> Sample:
>
> procedure Tdm.MySessionBeforeConnect(Sender: TObject);
> var
>   CurrentIP: string;
> begin
>   CurrentIP := RegReadCommonString('RemoteAddress');
>   if CurrentIP = '' then
>   begin
>     // Display a setup-form that requests the correct IP of EDBServer
>   end;
>   MySession.SessionType := stRemote;
>   MySession.RemoteAddress := CurrentIP;
> end;
>
> You can also use the "RemoteHost" property instead of the "RemoteAddress"
> property. In that case you have to assign the name of the remote machine.

Thanks

And if I want to keep the exe file and the database on the same machine
and just drag a shortcut to the users station?

Sorin

Tim

Moving to client server will solve this problem?

Sorin

Sorin


On client server there is only one machine that accesses the data - the server -  so the problem should go away.

Roy Lambert [Team Elevate]

Sorin,

<< Moving to client server will solve this problem? >>

Yes, absolutely.

--
Tim Young
Elevate Software
www.elevatesoft.com

Sorin,

<< The query is selected from several tables. To increase the buffer of all?
>>

I would start with the largest tables and work down from there to the
smallest tables.

<< Any specific buffer to increase page size, max row, etc.. or to increase
all? >>

Try a few MB at first, and see if there is any improvement.

<< Increasing will not have impact on others enviroment? The same app work
also as standalone and terminal/server. >>

Sure, it will have an impact on the memory consumption of each table (per
session) anywhere that it is used.

--
Tim Young
Elevate Software
www.elevatesoft.com

> If the environment is file server instead of client server, then I am
> pretty sure the problem is related with opportunistic locking settings on
> Windows server.
>
> Check windows registry
>
> HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\MRXSmb\Parameters\
> OplocksDisabled should be 1
>
> HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\LanmanServer\Parameters
> EnableOplocks should be 0
>
> BTW, my suggestion is to change to client/server.
> The application will run better (in general) than file server. It is more
> secure too.

Eduardo

I try your's suggestion and:

The Key "MRXSmb"  exist only on XP os, not in vista or win 7.
The parameters "OplocksDisabled" and " EnableOplocks" don't exist on any os.

Still I try to create them all, restart the computers but it doesn't have
any impact

Any more suggestion?

Thanks
Sorin

> I would start with the largest tables and work down from there to the
> smallest tables.
>
> << Any specific buffer to increase page size, max row, etc.. or to
> increase all? >>
>
> Try a few MB at first, and see if there is any improvement.
>
> << Increasing will not have impact on others enviroment? The same app work
> also as standalone and terminal/server. >>
>
> Sure, it will have an impact on the memory consumption of each table (per
> session) anywhere that it is used.

Tim

I try on 3 majors tables to increase with 5, 10, 20 mb without any impact

Thanks
Sorin

> << Moving to client server will solve this problem? >>

I also notice a big difference between open a query from a mapped driver
shortcut
and UNC shortcut.
It's jump on same computer from 1-2 seconds to 8-9 seconds.
Is this cause by the same windows locking?


Since I'm still afraid from the c/s ver is there a option to work temporarly
with both c/s and f/s?
What are the c/s tryal ver limits?

Thanks
Sorin

Sorin

Then I think I can´t help you.

Eduardo

Sorin,

<< I also notice a big difference between open a query from a mapped driver
shortcut and UNC shortcut. It's jump on same computer from 1-2 seconds to
8-9 seconds. Is this cause by the same windows locking? >>

I don't know exactly what causes it - this is all internal Microsoft OS
code, so your guess is as good as mine.

<< Since I'm still afraid from the c/s ver is there a option to work
temporarly with both c/s and f/s?  What are the c/s tryal ver limits? >>

Yes, you can work with both.  The trial version only allows for up to 3
concurrent sessions on the server, but you don't need the trial - just use
the EDB Server that comes with the STD version - it allows for up to 5
concurrent sesions on the server.

--
Tim Young
Elevate Software
www.elevatesoft.com