+5
As I mentioned in the title, searching in shop orders is too slow. There are 78,995 records here. Could this be slowing it down?
Approximately 40,000 records were created before 2018.These records will no longer be used. We want IFS not to look at these records while doing research? Is there any way to do this? Can we deactivate all records created before 2018?
We are using IFS APP 8 version.
Best answer by Buddhika Kurera
View original
+13
If these records are not required, consider deleting the shop orders.
Manufacturing\Shop Order\Order\Mass Delete Closed Shop Orders and Clockings
AFAIK, it is not possible to deactivate the SOs but you can archive the records in the database following the general database data archive.
Hope this helps !
+5
If these records are not required, consider deleting the shop orders.
Manufacturing\Shop Order\Order\Mass Delete Closed Shop Orders and Clockings
AFAIK, it is not possible to deactivate the SOs but you can archive the records in the database following the general database data archive.
Hope this helps !
Deleting old records worked. But you said “If these records were migrated, please check the indexes and etc in place”. Can you give more details or share images on this subject?
+9
A database specialist should be able to help you import or create the indexes you need. Table indexes are the database tools used to create fast table searches and connections between tables. You seem not to have any.
Table indexes are what is picked up by the application to show the user what search criteria is better and which are not so good to use for a search, in short search tips. If you use the Advanced Search screen, like you have in your screenshot, then to the very left there is a column that should show arrows pointing diagonally up or down, green arrows pointing up to the right and red pointing down to the right. The green arrows indicates that search on that field gives a fast response. Searching on combinations of fields with green arrows will make your search even faster. Searching on fields with red arrows slows down your search.
On looking at the screenshot from the original entry I see no green arrows pointing up to the right on the left column, only red arrows pointing down. There should be a number of green arrows: One on Order no. one on Part no, one on Site, perhaps one on Shop Order Type.
+5
A database specialist should be able to help you import or create the indexes you need. Table indexes are the database tools used to create fast table searches and connections between tables. You seem not to have any.
Table indexes are what is picked up by the application to show the user what search criteria is better and which are not so good to use for a search, in short search tips. If you use the Advanced Search screen, like you have in your screenshot, then to the very left there is a column that should show arrows pointing diagonally up or down, green arrows pointing up to the right and red pointing down to the right. The green arrows indicates that search on that field gives a fast response. Searching on combinations of fields with green arrows will make your search even faster. Searching on fields with red arrows slows down your search.
On looking at the screenshot from the original entry I see no green arrows pointing up to the right on the left column, only red arrows pointing down. There should be a number of green arrows: One on Order no. one on Part no, one on Site, perhaps one on Shop Order Type.
Thanx for detailed informations. Is there any documentation regarding table indexes?
+9
I believe there is a Tech help file but I cannot reach any APPS 8 environment so unfortunately I cannot advice you. on how to access it.
/Jonas
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
