INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

"Data Source" takes a long time

"Data Source" takes a long time

(OP)
Hi all,

Question: Is there any way to speed up View Source in InfoMaker?

Background Detail: Some customers are reporting that when they edit InfoMaker reports, the "View Source" takes a long time to produce the SQL (both in graphical and syntax modes).

I have investigated this internally, and it seems that InfoMaker (and this applies to version 9.0.1 build 7119 and version 10.5 build 4523) is trying to execute the SQL whenver you try to take a look at it.

Sometimes the delay before seeing the SQL can be quite significant - over 1 minute.

I'm sure there was an option somewhere that caused View Source to come up lightning fast, but (a) I can't find it now, and (b) it also turned off all syntax checking, meaning that you could get away with silly errors in your SQL and save them .... only to have them manifest themselves later as run-time errors.

For the database, we are using Oracle 10g, on which the problem is really bad in some cases.  Formerly we were using Oracle 9i, which was quite bad but not as bad as 10g.  Obviously, because of this, we are having to use the CBO because the RBO (which we've always used up to now) is deprecated.

Thanks in advance!

If you don't know what eschatology is then don't worry; it's not the end of the world.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close