Information générale
Catégorie:
Gestionnaire de rapports & Rapports
Versions des environnements
>I have a two tables, the parent table with the main information and the child table with the details. Both tables have over 1 million records in them. I created a few programs (2) that will print a report from these tables. In my first program I set a filter on the parent table, indexed the child table and set a relationship from the parent to the child. if the parent record has many child records only one of the child records will print. In my 2nd program i combined the two tables using a SELECT statement. This gave me the correct results but the select takes almost 5 minutes. Is there another method of printing from a one to many relationship?
>
>thank you in advance for your time and efforts
Did you join the tables on indexed column.
I created 2 tables and added 1 million rows each for testing (3 columns each).
The query took too long without using indexes but seconds with indexes.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement