General information
Category:
Coding, syntax & commands
>I have a application and it works :
>
>have one primary table with 1200 people Information
>and I have aprox. 30,000 records in a child table and is very
>slow consult the child table with a relation, when i need sum the
>amount of the child table for each record in the primary table, the system is very slow, i have index on IDCliente in my primary table and
>i have an Index in my child table Idcliente for make a relation and the relation works ok, but my sysetm is so slow, what I'm doing bad?
>how can a give more speed to my application?
>
>Sorry for my English
If you have SET DELETED ON, you should add an index on DELETED() to each table, this will speed up the process immensely, because otherwise each record is checked to determine if it is deleted or not.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only