That all depends on the size of the records, your network and the patience of your users! Normally, I wouldn't say that 100.000 records is much - although it should be enough for you to notice things being a bit slower with your left join as opposed to your inner join.

Set

-----Original Message-----
From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Sergio
Sent: 11. juni 2010 16:32
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: changing "join" for "left join" inside a stored procedure

> In case your next question is that this is a solution that is slow (it can be if customers is a huge table and you return all of it):

Thank you for your constant help! Very useful to me!
You've read my mind!! :)

I will try it for "not huge" tables... by the way... could you define "huge"...? 10.000, 50.000, 100.000 records?

s