RFI: SQL Optimization
Hi All,
We would like to improve the performance of the application. Some queries are causing slow performance and long-running queries:
1. Supposed we have obj-browse that retrieved data from a table with blob columns, what is the best way to increase the performance of the obj-browse? Should we create new columns for those being used in that activity? Or should we create columns for all the blob under that table? What do you suggest in handling these BLOB reads?
2. How should we handle or optimize those queries with typecasting and for those that uses functions or calculations?
Thanks in advance!
***Edited by Moderator: Pallavi to update platform capability tags***
***Edited by Moderator Marissa to update SR Details***
Incessant Technologies Pvt.Ltd
AU
Hi mgalleno,
Increasing performance when doing obj-Browse.
1.Specify max records in obj-Browse which is best practice.
2. Select only the columns that are necessary.and that are used in further operations. If the query is running on Data Table and if BLOB is not required its better to create Flat tables.
3. Usage of Functions and Casting on the data should be reduced as it will consume more time if more number of records are present.
Regards,
Chaitanya