boris Posted June 7, 2010 Report Share Posted June 7, 2010 I have a query that imports a lot of data (inserting millions of rows). It takes about 10 mins to import everythig. At the same time I want to run a small query but it takes ages to complete this query, usually after long query is completed. How I can destribute resources equally between queries so that small query finishes in 1-2 sec. while big query keeks runnings? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.