View Complete Thread | FoxWeb Forum Home
Search:
Date:    Msg ID:   
From:    Thread:   
Subject:   
I have an application that runs different SQL procedures. I have used the memlimit in the config.fpw to increase memory access and speed up the SQLs. However, changing these settings is causing the system actually to run the SQLs incorrectly and giving incorrect results. For example, I have in my databse 20 million records with data from different states. running a query for state='ma' and state='ny' wil bring in on state='ma' and ignore state='ny'. Changing the settings will bring both states. I also have an index on the state filed. Can anyone explain how this memlimit setup works in 2.6?