ADO.net只在指定的存储过程调用之后返回结果，还是在执行所有触发器之前才返回结果?

I am trying to record each words used in a nvarchar(max) field in my database and each word will become a data row and it takes a lot of time when I do it in one stored procedure. SO I have created another stored procedure which adds all the words as new data rows in another table but it takes very long and I dont want the user to wait for this operation. My solution was to run the time consuming insert into query in a separate process(system.thread) but now I am thinking of triggers. If I trigger the insertion of all words in a trigger, will the user still wait for all the insert queries, including the triggers? or will the sql run the stored procedure, return the results to the user and then the triggers will run? assuming triggers are after triggers.I am trying to record each words used in a nvar