Subject: | Re: Slow query
| Date: | 18 Aug 2021 16:41:42 -0400
| From: | "Tony" <tracy.fairbrother@btopenworld.com>
| Newsgroups: | comp.databases.paradox
|
"Kevin Zawicki" <numberjack@wi.rr.com> wrote:
>
>Need more info...
>
>going to be based on your machine.
>
>but maxfilehandles - 255 can help
>
>does the new machine have SSD drives?
>
>
>what do you mean by big tables?
>Rebuild them all even if they seem OK and retest.
>
>Yes SSD drive and I have rebuilt the tables. 335,000 records
>
>
>"Tony" <tracy.fairbrother@btopenworld.com> wrote:
>>
>>"Kevin Zawicki" <numberjack@wi.rr.com> wrote:
>>>
>>>
>>>Is everything local? tables? paradox?
>>>
>>>Did you copy the paradox files from old to new and miss a table index?
>>>
>>>What are the hard drives like? SSD?
>>>
>>>
>>>Check the DBE settings on old and new. Paradox install the same?
>>>
>>>
>>>More info needed?
>>>
>>>
>>>
>>>"Tony" <tracy.fairbrother@btopenworld.com> wrote:
>>>>
>>>>
>>>>
>>>>Hi can anyone help I have a brought a new laptop Acer it has 8mb memory
>>>I5
>>>>but the query seem to run really slowly compared to past laptops? Any
>help
>>>>would be appreciated. Thanks Tony
>>>
>>
>>Hi Kev its when I link queries it takes over 20 min if I link tables it
>works
>>fine on big databases but as soon as I link tables it takes a long time.
>>No its standalone. Its big tables but its taking far too long. What bde
>settings
>>would you recommend?
>
|