Hi Craig,
>it slows down terribly....
Unfortunately this is the nature of file based databases. The larger the
size of your data tables, the slower your app becomes on a network.
Having said that, the way your app is written can either put off the
inevitable for a while or lead you to it faster. For instance, if your
app uses a lot of queries on network tables you are going to find it
slowing down sooner rather than later. If you can use secondary indexes
with set range to get the views of the data you need, things will happen
a lot faster. There are multiple things like that that can help or
hinder you depending on how you chose to approach it. How large are the
data tables on the network?
However even in the best of cir***stances, the app will get
progressively slower as you get more data. If you are going to use this
app for any length of time and will keep adding a lot of data, the
answer is to convert the back end to a CS database. I've been there and
done that. I spent the last year converting a traditional Paradox app to
one which uses Paradox for the GUI and MS SQL server 2K for the
database. Everything runs off stored procedures on the server. The
difference is absolutely stunning. Things that used to take 30-45
seconds are now instantaneous. The improvement in speed is really
unbelievable. It is rock solid also. I know that's not what you wanted
to hear, but that has been my experience.
Regards,
RoyF
Craig wrote:
> For years my software has run quickly on a local drive but when there
are
> large files on network drives, it slows down terribly when moving from
> record to record.
>
> I am going to approach our IT department about, but before I do, I need
to
> know what questions to ask.
>
> My software is in a large hospital, but at this point it runs stand
alone
> (not netowkred) using Paradox 10 Runtime. I think they use Novel network
> What are the factors which will slow down performance when a database
runs
> on a network drive?
> I don't know where to start. I would like to get information, bring it
back
> to this forum and ask for help in sorting this out. Has anyone else run
into
> this problem?
>
> Thanks in advance
>
> Craig
>
>
|
