New Blog Post: RESTful Reporting

poor performance rb12 vs rb7

edited August 2010 in DADE
We recently migrated from rb 12

The point is that the qry rb 7 was executed two times.

In rb12 runs 3 times

Since 05/10/2009 we play this point and his answer was: (Nard Moseley)

"RB 11 includes enhancements to the SQL Text to allow AutoSearch and Linking
features. To accomplish this the Query has to rebuild the field type info
each time you modify the SQText."

Our problem is that performance with 12 rb really down too low.

We work with databases of up to 50 GB with very complicated statistics And
our customers instead of being happy with the new version, are very
frustrated and nervous because the list takes twice to process.

Please we need to give us a solution to the loss of performance.

For example:

If the report is not used "AutoSearch and Linking"do not rebuild the field
type info.

There must be the form of two properties setear

Autosearch: = False
Linking: = False

and then not to rebuild the field type info and so only run the sql 2.


Sebaot software


  • edited August 2010

    I created a patch for RB 12.01 that you can try. I emailed it to you.

    The size of your database, 50 GB, is not relevant unless you are doing a SQL
    Select on every row in the table. I recommend optimizing the database with
    appropriate indexes and using the SQL Where clause to limit the size of the
    result set. You want query performance to be fast.

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
  • edited August 2010
    Thank you for your prompt attention.

    Unfortunately the problem has not yet been solved.

    We are preparing a small program to help them understand and solve the


    Edgar Brtiez

  • edited October 2010
    Just wanted to post a follow up here, this issue has been resolved.

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.