6 Replies Latest reply on May 27, 2010 11:50 AM by musicmaker

    FilemakerPro 10 server Running Slow!!

    musicmaker

      Title

      FilemakerPro 10 server Running Slow!!

      Post

      Help!

      I have a small Database approximately 1500 items, 28 fields in each record and of those about 20 are indexed, no calculations, but each item has (3) (2-4 MP) photographs for inventory reference.  Searches are extremely slow.  If you do a find on a category of items it may take a minute or 2.  I need this thing to run faster.  The Server is a Mac Mini and have about 4 various MacPro’s running File Maker Pro 11 to access the database.

       

      Any thoughts??

       

      Thanks

       

        • 1. Re: FilemakerPro 10 server Running Slow!!
          musicmaker

          I should also mention that the photographs were imported one at a time directly into each record. Could this be what is slowing down the database?  I know there is a "Store reference only to the file" option on import.  Would it make sense to script export each photo to a database picture file, then re-insert picture with reference only to the path of the new location?  Would I be able to export all existing photos and have them remain associated with the record and photo number of each record they came from (rename?)so importing would be easy????

          • 2. Re: FilemakerPro 10 server Running Slow!!
            mrvodka

            I would store your images in a related table. It should help with the speed.

            • 3. Re: FilemakerPro 10 server Running Slow!!
              musicmaker

              Just so I understand.  Let's say I duplicate the database, then delete all information except say item number and the 3 photos on this new .  I then link them back to the other database in the manage option/relationships??

               

              Thanks so much for your input!

              • 4. Re: FilemakerPro 10 server Running Slow!!
                mrvodka

                No if you have 3 container fields in your current table, then you should actually have 3 records only using 1 container field in a related table. It can all be in the same db file if you want to.

                 

                • 5. Re: FilemakerPro 10 server Running Slow!!
                  mrvodka

                  Since this would be a one time thing you can use a crude script as such:

                   

                  Go to Layout [ "Parent" ]

                  Show All Records

                  Go To Record [ First ]

                  Loop

                      Set Variable [ $ID; pkParentID ]

                      Set Variable [ $container1; Photo1 ]

                      Set Variable [ $container2; Photo2 ]

                      Set Variable [ $container3; Photo3 ]

                   

                      Go to Layout [ "Images" ]  // New Table's Layout

                      If [ not IsEmpty ( $container1 ) ]

                          New Record

                          Set Field [ fkParentID; $ID ]

                          Set Field [ Photo; $container1 ]

                      End If

                      If [ not IsEmpty ( $container2 ) ]

                          New Record

                          Set Field [ fkParentID; $ID ]

                          Set Field [ Photo; $container2 ]

                      End If

                      If [ not IsEmpty ( $container3 ) ]

                         New Record

                         Set Field [ fkParentID; $ID ]

                         Set Field [ Photo; $container3 ]

                      End If

                      Go to Layout [ "Parent" ]

                      Go To Record [ Next; Exit After Last ]

                  End Loop

                   

                   

                   

                  Where "Parent" refers to your current table, pkParentID refers to the unique record ID for that parent record, "Images" refer to the new layout based on your new images table as well as the table name, and Photo1-3 refer to your 3 current container fields.

                   

                   

                  Basically, your structure should be like:

                   

                  Parent Table ( current table )

                  pkParentID ( auto-incrementing )

                  Photo1

                  Photo2

                  Photo3

                  Whatever Other Fields

                  ...

                   

                   

                  Images Table

                  pkImageID ( auto-incrementing )

                  fkParentID ( foreign key storing the related parent ID )

                  Photo

                   

                  • 6. Re: FilemakerPro 10 server Running Slow!!
                    musicmaker

                    Thank you so much...I have to digest this.  I do appreciate your help!