boris

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?