Many posts equals slow?

[Jokez]

I have Filemaker 7, and we have pictures that we have alot of searchwords on. So between the Image table and the Searchwords table we have a Image_Searchwords table.

That table contains about 32 000 posts, and its to darn slow to just make a new post in it! Why is that??? And it will be around 510 000 posts in it lately...

I have made sevral TOs from Image_Searchwords to see different types of searchwords, does that effect the speed of the Image_searchwords table??

Plz need tips badly!

Regards

Jocke

Edited November 1, 2005 by Guest

[Ender]

Certainly, FileMaker 7 should be able to handle hundreds of thousands of records without performance degradation.

There are many things that affect speed, including client hardware, server software and hardware, network speed, the database structure, and the database interface. It's hard for us to offer a suggestion without knowing more about what you have for these things.

One thing that can cause slow record creation is having the "Unique" option checked on a field's validation option. This option is not needed on auto-entered serial numbers.

[Jokez]

I have realized that I goes slow when I during the script that creates the post in Image_Searchword goes from my original layout with a hughe portal and a picture that is linked in to filemaker. When I go back to that layout it has to think for 1-2 seconds.

Maybe I have to have Filemaker performe the add in another window so I dont leave the current one at all? Do you think that changeing windows during scripts can slow things down?

Regards

Jocke

[Sanjai]

Sorry to interfere Ender. I would like to share my experience that if all the fields in an application are indexed that also terribly degrades the performance.

Avoiding any searches before a new record is created would help the situation.