Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 11 to 15 of 15 total |
Problem with a multi-users database access |
Tue, Feb 5 2013 4:14 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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 |
Tue, Feb 5 2013 2:24 PM | Permanent Link |
Mahistre | 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 |
Tue, Feb 5 2013 4:52 PM | Permanent Link |
Jan Ferguson Data Software Solutions, Inc. Team Elevate | 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 |
Wed, Feb 6 2013 3:08 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | 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] |
Wed, Feb 6 2013 4:19 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | 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 |
« Previous Page | Page 2 of 2 | |
Jump to Page: 1 2 |
This web page was last updated on Tuesday, May 7, 2024 at 06:25 PM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |