Slow performance in AFIS due to JACTG downloads

Please be advised that the JACTG table is designed for research purposes only. It is not designed to be used as an accounting extract dump of large amounts of data. The JACTG table is extremely large and contains an abundance of data. When researching and/or downloading the JACTG, AFIS can experience performance issues, especially when multiple users are trying to query at the same time. Please refine your queries to limit the amount of records.  This could include FY, APD, BFY, Fund, Function, Doc Code, and posting codes.  Refrain from using open ended queries on the JACTG or using it as an accounting extract dump. If we continue to experience performance issues due to agencies querying large amounts of data from the JACTG table, we will have to remove this feature. If you need assistance getting data out of AFIS, please contact your AFIS Liaison. 

Author
Jessica Shuster
Date