On Tue, Nov 1, 2016 at 4:49 PM, stardata.info <[email protected]>
wrote:
> 4 GB
>
Great your cache should not be set bigger than 1024. once again how big is
data file(file size), number of records?
Cache should *NOT* be set to adaptive
Is there any other stuff running on your server machine. How are setting in
4D re cpu priotities. How long for data flush. This is something
overlooked. If you are flushing every 20 minutes it will take 20 times
longer than every minute on average, but appear to be much slower, as there
is 20 times more to be flushed. In pre v15 I always set to 1 minute. In 15
and higher I set for between 15 and 30 seconds.
Regards
Chuck
--
-----------------------------------------------------------------------------------------
Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
Informed Solutions, Inc.
Brookline, MA 02446 USA Registered 4D Developer
Providers of 4D, Sybase & SQL Sever connectivity
http://www.informed-solutions.com
-----------------------------------------------------------------------------------------
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law. These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited. Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:[email protected]
**********************************************************************
