Jump to content

Conditional Value List On The Web


cybertron
 Share

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

Recommended Posts

  • Newbies

What I am trying to do is have a conditional value list on my sites search page.

Each client logs in, then when they access the search page they get a value list in the site field showing each site we do work at. The problem is the speed. the database has about 110,000 records and it takes 2-4 minutes to load the search page because each time it needs to gather the value list.

I have got this working two different ways.

1) Showing all records from a field in the value list but having the privileage set limited to displaying records that relate to the login name.

2) Working the same as the above but having the value list looking at another table that has about 250 records.

Both these are do what is needed but take far too much time. Anyone have an idea on how I can speed this up?

All fields are indexed and the only calculation in the who database is the one used to limit access to the records.

Link to comment
Share on other sites

This topic is 5677 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.