poor performance rb12 vs rb7

rbuser

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.

Regards

EdgarBritez
Sebaot software
www.sebaot.com

nardmoseley

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
www.digital-metaphors.com

rbuser

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
problem.

Regards

Edgar Brtiez
www.sebaot.com

nardmoseley

Just wanted to post a follow up here, this issue has been resolved.

--
Nard Moseley
Digital Metaphors
www.digital-metaphors.com