Hey
Performance depends on various factors that includes hardware also, alongwith how you are processing (using query based or sp).
As you said 1,00,000 orders to be sent, can you explain what was that? An human eye generally cannot took a pain for a few millisecond.
Moreover, pagination can help you to handle too much of data.
Good Luck