>Roy F wrote:
> 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.
In my experience, file-size is not a de-facto indicator of poor
performance,
and Roy's use of the word "terribly" is to me an indicator that the
application might be suffering from an as-yet undiagnosed anomaly. The
WireShark recommendation is an excellent one.
In a networked environment, full-table-scans are death, and maintained
indexes are absolutely, 100% crucial. "Surprises," such as table-lookups
and other file-access that you just might not be aware of, are unpleasant
surprises.
----
ChimneySweep(R): Fast(!) table repair at a click of the mouse!
http://www.sundialservices.com
|
