I think the image posting is not allowed here to display.
Below is the error message I see:
Note I have 2.75 GB free disk space.
*** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch
failed
SQL Message : -901Unsuccessful execution caused by system error that does
I have 8 GB RAM, how much else does it need ?
You may point temporary location configured in firebird.conf to a different
destination.
Could you help in, how do I configure to a different location using
firebird.conf file ?
So I could give a try.
Thanks.
On Monday, 8 June 2015 11:44
Hi Thomas Steinmaurer,
I have given temporary directories path as below and SQL is now executing and
showing the results as well.
TempDirectories = c:\temp.
But there is one speed issue I am facing, if I take off some fields which is of
type Blob sub_type 1 then sql execution takes 4 and half
I need all those fields. What I have observed is that non of these field
contains an images. All are text and all those text for respective records not
even have 500 characters data.
So, what I have decided is that to create new columns for very respective
column whose data type is Blob and
Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] schrieb am 08.06.2015
10:16:
Hi Thomas Steinmaurer,
I have given temporary directories path as below and SQL is now executing and
showing the results as well.
TempDirectories = c:\temp.
But there is one speed issue I am facing, if I
Hi
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
I think the image posting is not allowed here to display.
Below is the error message I see:
Note I have 2.75 GB free disk space.
*** IBPP::SQLException ***Context: Statement::FetchMessage: isc_dsql_fetch
failed
SQL Message : -901Unsuccessful execution caused by system error that does
notpreclude
There is enough free disk space (2.75 GB) available.
On Monday, 8 June 2015 10:08 AM, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] firebird-support@yahoogroups.com wrote:
Hi All,
I am running one SQL in that Master table has 78 thousand plus records and
detail table
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