Ticket #289 (closed defect: invalid)

Opened 19 years ago

Last modified 19 years ago

Reactor with Oracle tables runs schema queries 14 times per table

Reported by: zspitzer Owned by: somebody
Priority: normal Milestone:
Version: 2.0.304 Severity: critical
Keywords: Cc:

Description

using reactor and mg:u from the latest SVN

the qFields query that reactor generates when reverse engineerig an oracle schema takes at least 1 second to run and this is a on a fresh oracle 10gr2 db patchset 10.2.0.3.0, with stats updated on the sys schema

I have logged this against reactor http://trac.reactorframework.com/reactor/ticket/124

this is compounded because of the following problem

MG:U and reactor are running the same queries over and over again, to reverse engineer the table properties, like 14 times the same query for an eleven column table, and the same 14 times for a table with four columns, so it's not column related

I'm not sure if this is MG:U or Reactor

Change History

Changed 19 years ago by joe.rinehart

  • status changed from new to closed
  • resolution set to invalid

Reactor will cache schema results - not a MG issue.

Note: See TracTickets for help on using tickets.