You also need to optimize your hardware and network on your FileMaker Server machine. Just because you streamlined your solution during the design phase doesn't mean it's going to react efficiently across a LAN or WAN. People still request Linux support to this day. Linux FileMaker Server briefly ran on the Linux platform but was abandoned when FileMaker 7 was released. The index does take up space, so if a field is not going to be searched on or used as a match field in a relationship, set the Storage Options in Manage Database to never index that field. Most characters are indexed but you may be surprised what characters designate a new word other than a space. If you click into a field and type Command-I (Macintosh) or Ctrl-I (Windows), you can view the index of a field. In order to make finds as fast as possible, the first 100 characters of every word is indexed. Rather than trying to locate something by thumbing through each page, you look in the index and find all the pages numbers at once. Indexing FileMaker Pro indexes every word in a text field so that finds can be performed quickly. Email John Mark Osborne or call John Mark at (909) 393-4664 to find out more about this service. Over programming hurdles via GoToMeeting. Meta-consulting is a service Database Pros offers to help other developers The Philosophy of FileMaker recommends PCI! Support this site by clicking on a sponsor below or becoming a patron! The Philosophy of FileMaker - Server Optimization