Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1091
  • Last Modified:

Two TZQuery'ies connected via MasterSource

Hello Experts!

I have to TZQuery components.

They are providing data from two Master- Detail tables.

It looks like this:

1.

select * from table1 where index = 1;

2.

select * from table2;

These two TZQuery are connected together via MasterSource, MasterFields, LinkedFields and IndexFieldNames.

It works fine but slowly.

I wonder if I could make it work faster...?

Maybe I should avoid queries like:

select * from table2?

What is the best practice to realize this master- detail connection?

Thank you

panJames
0
panJames
Asked:
panJames
  • 7
  • 2
1 Solution
 
Geert GruwezOracle dbaCommented:
to provide tuning solution, you'll need to indicate what database you are using
in general:
minimize your column list (only select columns you really want)
minimize your rows returned (do you actually read more than 25 lines ?)

for master-detail you can usually combine in 1 query

select
  m.column1 master_col1,
  m.column2 master_col2,
  m.column3 master_col3,
  d.column1 detail_col1,
  d.column2 detail_col2
from table1 m
  left join table2 d on m.mastercolumn = d.mastercolumn
where m.index = 1;

displaying the data in the detail view can be done by applying a filter on the data in memory
0
 
Geert GruwezOracle dbaCommented:
when tuning a problem the basics should be checked too:
network > amount of data to copy
local pc > cpu load, memory,
database type > local, server, load
query > optimal execution path ?
0
 
Geert GruwezOracle dbaCommented:
delphi is all about code
if you don't supply code, it's mainly guessing where your problem is
0
Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

 
panJamesAuthor Commented:
"minimize your rows returned (do you actually read more than 25 lines ?)"

how do you make your query return only lets say maximum 25 lines?

Thank you

panJames
0
 
Geert GruwezOracle dbaCommented:
database type ?
0
 
Geert GruwezOracle dbaCommented:
mysql
select columns from table LIMIT 1, 25

oracle
select columns from table where rownum <= 25
> doesn't have a offset

in the properties of some query components you can find this:
FethAll: boolean; (default false)
FetchCount: 25; (default)

some grids like devexpress know this and can call FetchNext to get all data
0
 
Geert GruwezOracle dbaCommented:
Zeos lib components don't have this functionality
you'll have to use other components or do it with sql
0
 
panJamesAuthor Commented:
Firebird
0
 
Geert GruwezOracle dbaCommented:
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 7
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now