SQL query taking long time in Studio

An SQL query that takes about 1 second to run on DB is taking long time when run from Studio. The result of the query has 5472 data rows. Please suggest ways to improve the speed of execution of the query.

Hi,

can you please share your code or screenshot of code for better understanding of problem.

Thanks

The query is
select
ID,
ITEM_NUMBER,
REVISION,
ITEM_SUBCLASS,
ITEM_CATEGORY,
ITEM_LIFECYCLE,
ITEM_DESCRIPTION,
REV_INCORP_DATE,
REV_RELEASE_DATE,
EFFECTIVITY_DATE,
COMPLIANCY_CALC_DATE,
EXCLUDE_COMPLIANCE_ROLLUP,
OVERALL_COMPLIANCY,
TOP_LEVEL_COMPLIANCY_INDICATOR,
PRODUCT_HIERARCHY,
USER_ITEM_TYPE,
UOM,
RELIABILITY_GRADE,
L2_USE_CONDITION,
FITMEAN,
FITSTDDEV,
FIT_90CL,
STANDARD,
CPN_PBFREE_REQUIRED,
COMMODITY_CODE,
SUCM,
CONTROL_CODE,
RISK_RATING,
RISK_REASON_CODE,
RISK_COMMENT,
LIABILITY,
BUYER,
PUSH_VISIBILITY,
EMC_CRITICAL,
NEBS_CRITICAL,
SAFETY_CRITICAL,
NETWORK_CRITICAL,
IECEX_CRITICAL,
PN_REQUESTOR,
CREATED_DATE,
REQUESTING_BU,
SOURCE_SYSTEM,
LEGACY_PART_NUMBER,
LEGACY_PART_DESCRIPTION,
LEGACY_DATA_SOURCE,
ADDITIONAL_ITEM_DESCRIPTION,
CAD_REFERENCE_NUMBER,
CAD_REFERENCE_URL,
VID
from item master table where item_subclass = “item subclass”

I am using Run query activity to execute this on the DB and fetch data.

Hello @priya.pai

If you try to extract only few data, is it taking this much time? Can you try to fetch some 10 data (Top 10) and check how much time its taking?

Currently with Uipath how much time its taking for 5k records?

for <100 is pretty fast. tried for 500 and it took 1 min. so I assume it will take 5 min for 5000. Any way to reduce the execution time?

@priya.pai I don’t think there are some other solutions for this delay. Can you try changing the Command type(property ) and verify once.

Also inorder to avoid the timeout issue, give a higher timeout in the property.

1 Like

I have the same issue. Were you able to find a solution?