re-created the script with a new reference data source to find out where is the cause of the query slow down, meeting discussion with sir Jimmy and Mark about the script if not or optimized or there have something issue on the server as of the moment the simple query is taking time.