Sql / report help?

[mejia.j88]

oh snaps June7, it works perfect.


Thanks so a ton for your help.

[mejia.j88]

Hi June7,

I had marked this post as solved, and it is, i just have one little hang up.

i took your advice from post 9, and added the concat function on 1qry_UniqueOperators, the problem is when i try to run the query, it gets hung up; takes forreeevvverrrr to load.
given, the db is on a network, but it shoudlnt take THAT long to load (sometimes 10+ mins).
is there anything i could do with the query to speeds this up a tiny bit?

maybe truncate the query with the dates im interested in?
the query that feeds the report, 1qry_rptInspectionShiftYield, does have a between dates criteria.

[June7]

I've never had to use this function for my data. I don't know if it could be any faster. When I run your query from my laptop it takes about 4 seconds, which is a little slow for 346 records. I will take to work tomorrow and run from network server and see what happens.

[June7]

Tested at work, takes 6 seconds to run. So does the Glassing Inspection Shift Yield report.

[mejia.j88]

hmmmm i have 24,000 records on a network :S
it gets hung up.

[June7]

Can you test a copy on local drive?

[mejia.j88]

yep, i did, it is a little faster.
one thing i did was create a "in between dates" criteria for for the queries using that concat function; that way the function only works through those records and not every record in the table.
this has made it much faster.