[progress Communities] [progress Openedge Abl] Forum Post: Re: Lbia, Rcda, Srta, Dbi

  • Thread starter Thread starter gus bjorklund
  • Start date Start date
Status
Not open for further replies.
G

gus bjorklund

Guest
> On May 19, 2017, at 4:41 PM, ChUIMonster wrote: > > There are no parameters to control this -- you need to write better queries. while it’s true you should write better queries, there are a couple of the things you can do 0) set the -TN and -TB client startup parameters to their maximum values and see of that helps 1) compile with XREF and see if uour queries are using the indexes you think they should 2) add some indexes to suit the queries you are running. that might have undesireable consequences as creates and deletes will take slightly longer.=

Continue reading...
 
Status
Not open for further replies.
Back
Top