Jan


>
>You don't even have to recompile as Roy suggested (although you can). I
>use an INI file which has my RemotePort, RemoteHost, SessionType, etc.
>listed in the INI file (see example below).
>
>[Configuration]
>RemoteAddressRemoteHostSessionTypeRemotePort
>I simply read the information from the INI file in the data module's
>OnCreate event and plug the information into the appropriate properties
>before activating the session, database or tables.
>
>To make things easier on my clients, I created a small application I
>called "NetConfig" which allows them to enter the information into the
>fields (some fields have drop down picklists, ie., SessionType). They
>save the information and it writes it to the INI file.

Nice approach. But how is Mahistre's app going to do it without a recompile

Roy

Hello,

Well on That I have recompile and makes all these manipulations.
In fact we put everything on the server, the database and software, and the whole works perfectly, on the other hand if we use the software with the base on another server on the local network, filters are very slow.
We have probably to optimize filters and indexs but it is a surprise to have performance so bad between the two.

Thank you for your reponses
David

I only meant that he wouldn't have to recompile each time there was a
change in any of those parameters. (But I did see your so
yeah...you got me on this one.)
--
Jan


Roy Lambert wrote:

> Jan

> Nice approach. But how is Mahistre's app going to do it without a
> recompile

David

>Well on That I have recompile and makes all these manipulations.
>In fact we put everything on the server, the database and software, and the whole works perfectly, on the other hand if we use the software with the base on another server on the local network, filters are very slow.
>We have probably to optimize filters and indexs but it is a surprise to have performance so bad between the two.

How fast is the network, what other load, how much traffic, is on it?

Which AV software are you using - can you exclude the DBISAM tables from its actions?

There are, unfortunately, a lot of factors involved. As has already been suggested, where queries are involved look at the query plans. If its a filter have a look at the equivalent query in DBSys - that will tell you if indices are missing. Look at the stats that the server will give you for network traffic etc.

Roy Lambert [Team Elevate]

David,

<< In fact we put everything on the server, the database and software, and
the whole works perfectly, on the other hand if we use the software with the
base on another server on the local network, filters are very slow. We have
probably to optimize filters and indexs but it is a surprise to have
performance so bad between the two. >>

If you are using C/S, then the only decent configuration is going to be
putting the database on the same machine as the database server.  The only
exception to this is if you have a very fast SAN (storage area network).

Tim Young
Elevate Software
www.elevatesoft.com