asked on

Select with 5 different options

Hi Experts.

Here is my problem.

I have a database table with a lot of fields but the most relvenat fields are:

Office
User
Operation
Product
Type.

There is many users in many offices who make many operaitons over many products of many types.

I am giving the user the choice of select One or all the offices with one or all the users (There are many users in each office) with one or all the operations with one or all the products with one or all the types.

I need a solution to make a search the most efficient possible because the number of records in the table is thousands more than 500000 and this is for a simple consult that need to be as quickcly as possible.

Hope any one can help me, ask me for further information.

Thanks

SOLUTION

JackOfPH

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Raynard7

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

JackOfPH

Link to give you more Idea...
https://www.experts-exchange.com/questions/21903503/Select-Datagrid-row-to-populate-form.html

Alfredo Luis Torres Serrano

ASKER

The use of SQL is not the best option because is it not just for Windows and i am looking the best performance not mater which database engine.

Still looking for solution

Raynard7

You would be able to write this using an ANSI standard SQL and use this across database engines. You should be able to use the same SQL for MySql, Oracle, Ms SQL and perhaps even access.

You mention that you have a "database table" so if you are not using SQL to retreive the data - how do you want to retreive it?

Are you looking for some sort of recursive sorting algorithm to go through your table and find the data?

Can you be more specific on what you are looking for?

ASKER CERTIFIED SOLUTION

gafoorgk

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Alfredo Luis Torres Serrano

ASKER

I have decided to use a mixed way using Logical Views and simple select with keys to thoe logicals ans sql whre needed.

Thsnka all, I Will split the points