Searching across databases

[Jondb]

Hi-

 

I have a database which contains 10 years worth of records. It has become extremely sluggish, especially when performing scripts, so I want to create an empty clone of the database for continued use.

 

Is there a way to link the two databases so that any search performed on the new database will also search the old one?

 

Thanks

Jon

[comment]

I have a database which contains 10 years worth of records.

 

How many records is that?

[Jondb]

There are a number of tables, but the principal ones have approx 1380, 780 and 580 records respectively.

 

Each of these features a container field with a thumbnail image in it. All these images are downsized to about 60kb before being imported, but they are probably the main contributor to the overall size of the database, which currently stands at 155mb.

 

I'm running FMP12 on Mac OS 10.6.8.

[comment]

There are a number of tables, but the principal ones have approx 1380, 780 and 580 records respectively.

 

That's practically nothing, so if the solution is "sluggish" you need to look for the real reason before coming up with a solution - such as trying to display too many unstored calculations at once, or layouts being too graphics-heavy, for example.

 

In any case, splitting it up into two files is more likely to cause more problems than it solves (if it solves any).

[Jondb]

Thanks, that's a useful observation. I'll take a look at the processes to see what I can streamline.

 

Cheers

Jon