waldronmg

FMP15 SELECT with JOIN causes SELECT * COUNT

Discussion created by waldronmg on Feb 13, 2017
Latest reply on Feb 13, 2017 by waldronmg

When A SELECT is executed for 1 table, it retrieves records quickly (table has 500,000 records).

 

When a JOIN is included for 2 tables, it creates a SELECT * COUNT ........ which causes the first page display to go from 3 seconds to 36 seconds.

 

Trace shows this.

 

I know everyone will want to know a lot of things, but I just have a basic question:

 

Is there anyway to prevent the SELECT * COUNT when doing a JOIN?

 

Thanks

 

Mike

Outcomes