Paradox Community

Items in comp.databases.paradox

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?
>


Copyright © 2004 thedbcommunity.com