Jump to content

Slow Portals


kilby
 Share

This topic is 5770 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Hello

I've created a database that archives all of our company emails. There are currently over 5000 records in the database. I've tried using a portal and a custom sort key for subject, email name & date. Sorting the portal can take up to 10 seconds or more, so its quite slow & painful to use. The custom sort key is a global field and is unstored so indexing can't be turned on for this field.

Is it that portals are just to slow for this and I should stick to list views? Or am I doing someting wrong?

Main reason I wanted to use portals, I can have a highlight field in a row, I can also multiselect rows (with a hightlight as well) and the interface is quite neat & clear.

Thnxs

Kilby

Link to comment
Share on other sites

There are a couple of things that you say in your post that I don't understand, and that indicate some fundamental problems...

"The custom sort key is a global field and is unstored"

Global fields cannot be used for sorting, so something is definately amiss here. Sorting any unstored field is always slow, it's got nothing to do with the portal itself.

"Main reason I wanted to use portals... I can also multiselect rows"

This is news to me... only one portal row can be selected at any time, though you can use portal row selection tricks to give the appearance of multiple row selection.

Link to comment
Share on other sites

Hi Vaughan

Sorry about the confusion. Your right the sort key which is a calculation is not global, but is unstored. The global field is just the field that the calculation uses to determine which column it is sorting, the date, name or subject.

As for multiselecting rows, yes this is the multi-key selection trick which I've picked off the web.

Link to comment
Share on other sites

okay, I've also looked at various portal sorting techniques around. There seems to plenty of example files to download. They all use a unstored calculation as the sort key. So if I want to sort a portal, fast, in FM7, how do I do this?

Link to comment
Share on other sites

So if I want to sort a portal, fast, in FM7, how do I do this?

Hi Kilby,

You might do it by restricting the number of related records. Does that portal really need to sort ALL of the 5,000 related records? Aren't Users sorting in various ways to bring their desired results to the top where they can see them? Surely they aren't going to scroll all 5,000. In fact, they are performing the sort to FIND. So you might consider providing filters.

You can have a nice global calc for the left key. They could enter a global date popup or range, which would display conditional global popup of associated email addresses (called conditional value list) which could provide global popup of associated subjects (if you REALLY want to drill down). Global multikey to standard field and regular global to multikey or any combination thereof. I rarely dynamically sort portals because I bring the information to the top (within easy portal scroll) for them then standard default sort is enough. So consider restricting the relationship further based upon their conditions (and you can stop the left key from producing ANYTHING until criteria has been selected so they can't sort before it's filtered). Dynamic sort (if needed at all) would then be very quick because it would be working on a small number of related. And multiple selection (and writing IDs to global key) can still take place just as well.

Just an idea ... :wink2:

LaRetta

Link to comment
Share on other sites

Hi LaRetta

Thats a great idea, it adds greater flexibility for drilling down to the right message and would speed things up tremendously.

FM7 also has much better flexibility for creating complicated relationship.

Thnxs

Kilby

Link to comment
Share on other sites

This topic is 5770 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.