Paradox Community

Items in comp.databases.paradox

Subject:Re: Slow query
Date:17 Aug 2021 23:20:59 -0400
From:"Kevin Zawicki" <numberjack@wi.rr.com>
Newsgroups:comp.databases.paradox

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.




"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