sudden slow search results

[Flanzy]

I am using FM pro 4 with CHML on a G4, 450 processor. A client can enter through an ISP link and search a data base. It's been working fine for months now. But yesterday the search suddenly started taking forever and I don't understand why. Searching the data base on this computer is instantaneous. Using Explorer or Netscape to go to other sites is very fast. So I assume by themselves, each is okay. I use a specific port for access to the data base. The firewall allows for that. I use vicomsoft gateway to network several computers for internet access. This slowdown is bad for survival. Does anyone have any ideas of what might be wrong? The data base fields are indexed. The whole base if under 150 MB. I have many GBs of space available on my HD. Could I have unknowingly added something to the search script to slow it down? I have exhausted all the things to check that I know of. [color:"black"]

[Steve T.]

Hi, Flanzy! IMO, FMP has very modest hardware needs so you are probably suffering from a setting/design problem. Check your field settings and calcs for proper index/unstored configurations and have your (script?) execute on a blank/minimalist layout. One of our "slowdown" problems was -max on hitlist return. The FMP search was fast but the web user waited 2+ minutes for results page to show. We reduced -max and it came back to speedy. Is this the same w/you? When a web user executes a search, do you see it instantly in FMP? If so, it's not FMP, it's Web Companion trying to return a big hit list or something.

Umm.. I hope you are using Custom Web Publishing. If you are Instant Web Publishing, I don't know if there's much you can do to make adjustments. --ST

[Unable]

A search should not require a ScriptMaker script.

[Anatoli]

Also, in my tests FM5 is 5-7 times faster in web searches than FM4 in slightly more complicated CDML.

Test that with evaluation FM5.

[Garry Claridge]

Your database may have become corrupt!

Make an empty copy, then transfer the data across to that.

Good Luck.

Garry

[BuddySystems]

It's easy to see if this is a filemaker issue - just wait to see how long it takes for the "refresh" to occur when the search happens from the web. If it takes x seconds, and is not instantaneous, you know it's Filemaker. If not, it's something else, i.e. PC, network etc.

[Flanzy]

Thanks for all the responses so far. FM 5 might be faster, but I own 4 don't have the money to move up. Not sure I need to anyway. Anyone can try see the slowness for themselves if they care to. Go to www.monroestreetbooks.com and "search our inventory" Steve T. - right now I'm doing 10 results on a page. I don't know if that's the problem. When I try a search out on the same machine, once I start the search I click into the products database and get a command icon with a blinking period. I used to get this until the results came up and it all happened fairly quickly. (Whenever I restarted I'd need to do a few searches to get everything indexed, but after that a search was fairly fast.) Now the icon gets replaced by an arrow and the system is frozen whenever it's doing a search. I used to be able to do other things while it was searching.Now I can't. I know when someone is searching because I can't do anything on the computer. I index all the fields because I thought that's how I would get the fastest results. Is this not true?

[Unable]

Yup, it is running slowly. No I don

[Flanzy]

I removed the customer database info as soon as I saw your message. The fellow who helped me set it up said that would NOT be a problem. Obviously he was wrong. THANKS FOR TELL ING ME.

I don't know how you got into it - and would like to know. Anyway, we don't need to keep that info so suppose we just delete it as soon as we get it? or can someone be looking at it 24/7 and pick it up as soon as it comes in?

I need to look at the thread you gave me which I will do today and see if I understand. Flanzy

[Unable]

I've sent you a personal message.

[Flanzy]

Could you please resend? I can't find it.

[Unable]

It is not at your "My Home" page? Gah. I did not save a copy, it was extemporaneous.