Dear Friends:
I have a problem with my Sybase database and VB6 Application.
The problem is when the database grows more than 200,000 records per table, and while runing an inner join statement in between 5 tables the time that it checks for the first record of the result table is taking around 3-5 seconds which is slow.
What I did to solve this problem is that I referenced my tables' primary keys, and it's now taking less time.
Can anyone advise me how to solve this problem (Time delay while running innerjoins over 5 big tables), or what i did is the ideal?
Thanks.
I have a problem with my Sybase database and VB6 Application.
The problem is when the database grows more than 200,000 records per table, and while runing an inner join statement in between 5 tables the time that it checks for the first record of the result table is taking around 3-5 seconds which is slow.
What I did to solve this problem is that I referenced my tables' primary keys, and it's now taking less time.
Can anyone advise me how to solve this problem (Time delay while running innerjoins over 5 big tables), or what i did is the ideal?
Thanks.