SQL sent from D2.01 to Oracle via SQL*Net D2.01

Mike Destein

Delphi Developer

Mon, 10 May 1999 03:00:00 GMT

SQL sent from D2.01 to Oracle via SQL*Net D2.01

Quote

Relational Technology International wrote:

> Hi

> I have noticed that when I create a parameterised TQuery object which
> returns data from Oracle 7.2 via SQL*Net, the SQL Monitor shows me that
> even if the query selected 3 columns from a possible 20 in the table,
> the SQL statement sent to the server is rebuilt and selects all columns
> in the table. I only have 3 data aware fields on the form and so only
> see the 3 cols. requested, but this seems to me to create an unnecessary
> amount of network traffic - this will be of concern when we go into
> production.

> Why does this happen and how can I avoid it?

> When I build the same TQuery using ODBC, the SQL Monitor shows that the
> proper statement is being executed, selecting only the columns I
> specified. That's the behaviour I expect from SQL*Net.

> TIA
> Lisa Ward
> l...@rti.co.nz

Lisa,

What is the SQL statement in the TQuery.SQL property?

Mike

Relational Technology Internationa

Delphi Developer

Mon, 10 May 1999 03:00:00 GMT

Re:SQL sent from D2.01 to Oracle via SQL*Net D2.01

I have noticed that when I create a parameterised TQuery object which
returns data from Oracle 7.2 via SQL*Net, the SQL Monitor shows me that
even if the query selected 3 columns from a possible 20 in the table,
the SQL statement sent to the server is rebuilt and selects all columns
in the table. I only have 3 data aware fields on the form and so only
see the 3 cols. requested, but this seems to me to create an unnecessary
amount of network traffic - this will be of concern when we go into
production.

Why does this happen and how can I avoid it?

When I build the same TQuery using ODBC, the SQL Monitor shows that the
proper statement is being executed, selecting only the columns I
specified. That's the behaviour I expect from SQL*Net.

TIA
Lisa Ward
l...@rti.co.nz

Vija

Delphi Developer

Tue, 11 May 1999 03:00:00 GMT

Re:SQL sent from D2.01 to Oracle via SQL*Net D2.01

Quote

Relational Technology International wrote:

> Hi

> I have noticed that when I create a parameterised TQuery object which
> returns data from Oracle 7.2 via SQL*Net, the SQL Monitor shows me that
> even if the query selected 3 columns from a possible 20 in the table,
> the SQL statement sent to the server is rebuilt and selects all columns
> in the table. I only have 3 data aware fields on the form and so only
> see the 3 cols. requested, but this seems to me to create an unnecessary
> amount of network traffic - this will be of concern when we go into
> production.

> Why does this happen and how can I avoid it?

> When I build the same TQuery using ODBC, the SQL Monitor shows that the
> proper statement is being executed, selecting only the columns I
> specified. That's the behaviour I expect from SQL*Net.

> TIA
> Lisa Ward
> l...@rti.co.nz

Sounds like the property RequestLive = True in your TQuery component.
Make this False and your problem should go away.

Vijay

Other Threads

1. D2: Fatal bug in DBLookupComboBox and ListBox - testdblu.zip [01/01]

2. SQL Anywhere does not work with D2.01

3. D2.0 versus D2.01 (Convertible?)

4. How to tell D2.01 from D2.0?

5. D2.01 && Oracle 8.05

6. D2.01: Internet Solution Pack expired!

7. memory leak in D2.01 + BDE 3.11

8. D2.01/Sybase: App hangs on duplicate key violation

9. DB Lookup Combo Box problems in D2.01

10. D2.01: AppendRecord and OnPostError event problem