Having a problem with FMP10a.
When I create a new record in a database, it takes about 60-80
seconds for the record to become available. In between the time I
hit the cmd-N key and the record's availability, I get the multi-
colored spinning ball.
This is a database that was originally created in FMP5 and has
been transported up to FMP10 through FMP6 and FMP9.
It has 26,000+ records in it. Mostly text but with some images.
There is full indexing on the primary text field, which does have
some lengthy text in some records.
The datafile is being offered up on another machine running it in
standard FMP10. It has NO DELAYS in generating and making
available a new record.
What could be causing this problem?
To make it easier for us to sort this out, Chuck, could you
identify (such as Computer A, Computer B, etc.):
(1) what machine the files live on,
Data file is on and offered up by a 1.0 GHz G4 operating on 10.4.11
and using standard FMP10.
(2) what machine has opened them,
Data file is being opened and generating new records slowly on a
MacBook Pro operating on 10.5.8 and using FMP10a.
(3) what machine you're using to create new records in them,
The machine in item 2 (above). However, as I mentioned in the
earlier posting, the machine in item 1 (above) generates new
records in that data file in the normally accepted time of less
than a second.
(4) whether you're using FMP Server,
Not using Server. Just the machine described in item 1 (above).
(5) how the machines are networked, and
Problem occurs whether using the hard-wire LAN connection or using
the wifi portion of the LAN.
(6) whether the problem occurs with ALL files or just the one with
the 26,000 records.
Just the one datafile. Other datafiles, not quite as large, don't
seem to have this problem.
Size of the problematic data file is 927MB.
Well, I've got only 3 ideas, and frankly none of them would account
for delays of up to a minute, but they'll add to your store of info
for trouble-shooting purposes.
(1) At some point when nobody else is using the file, close it on the
G4. Then try opening it de novo directly from the MacBook Pro's copy
of FMP 10A (using the "Open" command, not "Open Remote", and
navigating to it over the network) and see what kind of performance
you get when creating new records.
(2) At this point, since you've got the file open anyway, use FMP
10A's "File Maintenance" tools (under the "Tools" menu) to compact
and optimize the file.
(3) After you revert to your normal set-up (file hosted by the G4,
with the MacBook as guest), try creating new records from the
MacBook when the G4 is running FMP as the foreground app, then again
with FMP as a background app (with some other program running in the
foreground on the G4) and time the difference in record availability.
My best guess is that you've got a network problem of some sort, and
none of the above techniques will resolve that for you, nor can I,
since I'm not a network guy. But what I've suggested should slightly
improve your performance after you get the big problem resolved and,
in the meantime, they'll provide you with more info to hand over to
your network trouble-shooter.
Good luck, Chuck.
