MitchJohnson

We have a database of over 300,000 customers. We recently had an independent contractor redesign our invoicing system. He told me that on a PC these searches and indexing of large parts of the database don't take much time at all but on our Macs it takes an ungodly amount of time. We are running G4's running OS 9 w/ 400 mhz processors with 192 mb of ram over an ethernet network. The size of the individual customer profiles is relatively small so the amount of data that filemaker has to weed through is relatively small. I have maximized the ram allocation to filemaker to the amount that tech support said would be enough (which is 45 mb) she said that anymore ram allocation wouldn't make for much speed improvement. Filemaker is the only program our host computer runs aside from the system. Is there any other way to speed up these functions, is something getting crossed up in the searches, etc. Any ideas would be appreciated. [ September 19, 2001: Message edited by: MitchJ11 ]

Thanks for the great input...I will run these items by him and see what he says!! Thanks so much...I KNEW it wasn't a "Mac" thing . [ September 19, 2001: Message edited by: MitchJ11 ]

G4 / 400Mhz / 192mb. We have a database of over 300,000 customers. When we need to update/search/index etc. large amounts of this database it seems to take forever. We had an independent person set up our new invoicing / database system. He worked only w/ the PC version in the past. He seems to think that similar functions and sized databases on the PC run MUCH faster than our Mac set-up. We are running a 1000/T ethernet so our network hums. Why would we experience such perfoemance slowdown? Filemaker tech support said to allocate 45 mb of ram...any more would be negligable in perfomance benefit. Virtual memory is off (We have 192 mb of ram so no need for VM correct?) Can we speed this up? Just assigning aource coades to 50,000 customer profiles has taken over an hour and a half. HELP!