Subject Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database
Author Robert martin

I don't know what the error message is, you didn't include it! but it is
likely your join is wrong and returning one of every detail record for
every header (i.e. 78000 * 3000 records !)

Check your query and make sure the detail records are linked to the
master correctly (i.e. JOIN detail d ON d.ForeignkeyField =

Post your SQL if you cant see the cause :)


On 8/06/2015 4:49 p.m., Vishal Tiwari vishualsoft@...
[firebird-support] wrote:
> There is enough free disk space (2.75 GB) available.
> On Monday, 8 June 2015 10:08 AM, "Vishal Tiwari vishualsoft@...
> [firebird-support]" <> wrote:
> Hi All,
> I am running one SQL in that Master table has 78 thousand plus records
> and detail table has 4 Laks and 3 thousand plus records. I have used
> Inner Join on the primary key of Master table with the column in the
> Detail Table.
> When I execute with small size database, but with this database when I
> run SQL using Flamerobin, I get below error.
> Please help.
> With Best Regards.
> Vishal
> [Non-text portions of this message have been removed]