ipskalsi
Last Activity: Oct 9 '12, 12:50 PM
Joined: Oct 3 '12
Location:
-
is there is any option to make is fast.? -
Its has 1 parent table and many child tables. all the insert update delete fetch commands execute on parent table.Leave a comment:
-
Slow in fetching records from table using left join
I have a table Multiple user at same time perform multiple operation on that table like insert , update , fetch etc. During fetching records i use many left outer join which decrease the performance. Is there is any solution to fetch the records fast. or i have to change the structue of table using normilisation.
any alternate of join.?
this is final query that executed..
...Code:select `customer`.`customerid`
Last edited by zmbd; Oct 3 '12, 10:49 AM. Reason: When posting VBA/HTML/XML/SQL please use the <CODE/> formatting button.
No activity results to display
Leave a comment: