I just tried samething in my office PC. FB takes 3 sec whereas IB
takes 4 sec. I guess, something wrong in my home PC FB
configuration?? or something else.... I have to check out.
Sorry for bothering you guyz.
Please ignore this..

--- In firebird-support@yahoogroups.com, "hi_feroz" <hi_feroz@y...>
wrote:

>
> Hi,
> Following SQL takes 4 sec in IB 6.0.2 and more than 30 sec in FB
> 1.5.2 and somtimes, FB even hangs when I run this. It takes 100%

CPU

> and hangs.
>
> SELECT
> R.CRS_CODE, R.MATRIC_NO, R.CRS_SECTION,
> R.STU_CRS_STATUS_CODE,
> R.CRS_NAME, R.CRS_CR_HRS,
> O.CRS_CODE, O.VNU_CODE, O.VNU_CODE_2,
> O.VNU_CODE_3,O.SLOT_DESC, O.SLOT_DESC_2, O.SLOT_DESC_3,
> S.STU_NAME, S.STU_PRG_CODE,
> CR.TOTAL_CR_HRS
> FROM CRSREGCRE R, CRSOFFERCRE O, STUMST S, CREDIT_HRS_REG
> ('2004200501') CR
> WHERE R.MATRIC_NO = S.MATRIC_NO
> AND R.CRS_CODE = O.CRS_CODE
> AND R.CRS_SECTION = O.CRS_SECTION
> AND R.STR_CODE = O.STR_CODE
> AND R.MATRIC_NO = CR.MATRIC_NO
> AND R.STR_CODE = '2004200501'
> ORDER BY R.MATRIC_NO, R.CRS_CODE
>
> All the Fields in where clause are indexed except CRS_SECTION. It
> doesnt make any difference.. I tried.
>
> The procedure that I call in SQL is simple:
>
>
> CREATE PROCEDURE CREDIT_HRS_REG (
> I_STR_CODE VarChar(10))
> returns (
> MATRIC_NO VarChar(15),
> TOTAL_CR_HRS Integer)
> AS
> BEGIN
> FOR
> SELECT MATRIC_NO, SUM(CRS_CR_HRS) AS TOTAL_CR_HRS
> FROM CRSREGCRE
> WHERE STR_CODE = :I_STR_CODE
> AND STU_CRS_STATUS_CODE = 'R'
> GROUP BY MATRIC_NO
> INTO :MATRIC_NO,
> :TOTAL_CR_HRS
> Do
> Begin
> SUSPEND;
> End
>
> END
>
> What could be the problem? Even if I take the procedure out and its
> respective fields from the query.... FB still takes much longet

than

> IB. I tried many other procedures and queries, FB in most cases

runs

> much faster than IB. I am a little lost, why in this case it takes
> longer?
>
> OS = Windows XP
> Processor = P4 2GHz
> RAM = 256MB
> FB and IB installed on same machine. But I run only one at a time
> manually to do the test.
> Originally DB was created in IB. I did the backup and restore when
> using FB but still using the .GDB extension.
> Drive which has database... system restore thing in XP is set off.
> I use Workbench. I also tried in IBO COnsole and IB Console...
>
> Any ideas?
>
> Feroz