Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1136
  • Last Modified:

Performance impact of Rowset Size = 0?

I have an issue with my application that apparently (according to my research on the net) can be fixed by setting Rowset Size to 0 or installing a different version of the BDE. The application is deployed on over a dozen Citrix servers, so updating the BDE is the less attractive of the two options.

I'm just wondering if there will be any negative impact on performance due to setting Rowset Size to 0.

Rowset Size is currently at 20. I use Oracle, in case that matters.

Ron

0
FeralCTO
Asked:
FeralCTO
  • 2
1 Solution
 
Mohammed NasmanSoftware DeveloperCommented:
Hello
 
   I haven't used BDE from long time, but setting the rowset size = 0 will reduce the performance, set this property to more than 20 will give better performance,

I prefer you to update the BDE to the latest version, because it's remove the old bugs that you have, try it in one server and see the diffrence
0
 
FeralCTOAuthor Commented:
Any idea as to how much performance degradation by setting ROWSET SIZE to 0?
0
 
Mohammed NasmanSoftware DeveloperCommented:
it's depend on your application, try to test that, if you don't return much rows, maybe you will not see big differents
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now