1 Reply Latest reply on Oct 5, 2011 3:19 AM by rjlevesque

    massive portal slowdown

    gizmocreative

      Title

      massive portal slowdown

      Post

      Hi all,

      I have been heads down on a new database that has been a godsend for my work. I have managed to combine sales, graphics, logistics, accounts and admin departments, but I have had a few issues with accounts and admin departments having major slowdowns

      to illustrate the layout the database is constructed as:

      customers -< orders

      Staff -< orders

      accounts -< orders

      admin -< orders

      orders -< graphics item >- Graphics department

       

      essentially most departments are linked into a one to many relationship with the orders table. for staff, each staff member has a staffID and each order is linked by that individual id. So i have made a layout that each sales member can see 6 filtered portals showing orders in various states. The has absolutely no issues whatsoever. The graphics department is pretty much the same story, but it is linked to graphics items with a portal. 

      With the accounts and admin sections, I need on page that is essentially a layout that shows filtered portals of all the orders. because i only need one page for those sections I made a single record with an ID field (adminID or accountsID) then a matching field in the orders and made that field a calculation that is "=1". There is over 7500 orders entries and it takes over a minute sometimes to load the admin and accounts layouts. there is zero load time for the staff layout. did i make the relationship incorrectly? or do i need to adjust indexing. I guess the sorting of over 7500 records would be time consuming, but i thought this software could handle that with a bit more speed.

       

      any help would be appreciated and if further information is required, please let me know and i will supply it.

        • 1. Re: massive portal slowdown
          rjlevesque

          With the accounts and admin sections, I need on page that is essentially a layout that shows filtered portals of all the orders. because i only need one page for those sections I made a single record with an ID field (adminID or accountsID) then a matching field in the orders and made that field a calculation that is "=1".

          ---------------------------------------------------------------------------------

          Um, this is a bit confusing but I think this is where your issue may lay...

          However, any database with many records will slow over time. There are a few things you could do to ease this issue like adding progress bars so that the end-user doesn't keep clicking thinking nothing is happening.

          As for speeding it up...I would love to help you do so, but something like this one I would need to get my hands on it, or at least "look" at how the tables are setup. (I'm not real good at imagining all this in my head - LOL)

          Got some screenshots?

          An empty version we can see?

          (dropbox.com)