I have a report that takes 60 seconds to show all information about all products, but when I create a prompt just to show the information about one product it takes 8 minutes to show.
Should not be otherwise, the report that show all information about all products it takes 8 minutes and the report that show the information about one product take 60 seconds ? Do you have any idea what could be happens ?
Thanks,
Is it showing all information about all products or just showing you the 1st page? Export it to Excel and see how long it takes. One reason why selecting one product would take longer is because there is no index to support the search so it scans till it finds it.
it showing all information about all products.
Is it possible create a index to a criteria like name product ?