Create a taf or tml with the <@serverstatus> tag. look at the results. What are the average query times? This will help you find the bottleneck. Also check the size of cache used and make sure that you have more assigned. Witango uses the cache very well, and one of the greatest improvements since tango2000 on the mac. The cache on t2000 was almost useless. After you tune all of these things, the greatest speed improvement will come from upgrading your dbms.
Robert.
On Friday, August 1, 2003, at 04:34 AM, Dan Stein wrote:
Sam, Is everything running on one machine/ If so moving the FMP DB's to a different machine should help.
Also on the Witango Webster machine increasing the RAM to 1G should help.
Sure a G5 is going to be a lot faster. Even a G4 Dual 1.5 or whatever the
dual is now would be a lot faster.
There are several alternatives in the G4 line also you might consider and
Xserve or the G5
I am happy to provide the Witango list folks a close to reseller price and I
can do custom configurations from the apple build to order store so if you
contact me off list I will give you a few price quotes and specs.
on 8/1/03 7:10, Jason Pamental at [EMAIL PROTECTED] wrote:
Sam,
Maybe a test of the JDBC connector? That might give you a speed boost
there and should require a minimal amount of work on the existing files.
The connection speed may be slower than ODBC, but should be faster than
the current AppleEvents method of communication.
Jason
On Friday, August 1, 2003, at 03:27 AM, Sam Bartels wrote:
I only noticed a marginal speed improvement when upgrading from
OS9/FileMaker 5.5/WebStar 4.4/Tango2000 to OSX/FileMaker6/Witango5. I
was
under the impression the speed difference would be significant. Sadly
the
client insists on the FileMaker database, so what can I do to improve
the
speed? Would an upgrade to a G5 make a big difference? The server is
a 1st
generation G4, 512MB RAM, 400MHz.
Any help would be appreciated - and I well know SQL would be a far faster database.
---
Sam Bartels [EMAIL PROTECTED]
_____________________________________________________________________ __
_
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
-- Dan Stein Digital Software Solutions 799 Evergreen Circle Telford PA 18969 Land: 215-799-0192 Mobile: 610-256-2843 Fax 413-410-9682 FMP, WiTango, EDI,SQL 2000 [EMAIL PROTECTED] www.dss-db.com
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
