[firebird-support] time for 1600000 select

[pluto.pippo66]

Hi all

I have aproblem with select fuction

this is my function in C :

int ReadValDbase(ISC_STATUS_ARRAY  status,char* namedb,char* selstr,char* value)
{
        char                        empdb[128];
        char                        __Ex_value[128];
        SQL_VARCHAR(20)                 field_name;
        isc_tr_handle               trans = NULL;     /* transaction handle */
        isc_stmt_handle             stmt = NULL;      /* statement handle */
        XSQLDA *                    sqlda;
        long                        fetch_stat, blob_stat,long_field_name;
        short                       flag0 = 0,
                                                                flag1 = 0,
                                                                flag2 = 0;
        short                                   nullind;
        int                                                     
int_field_name,success;

        memset(__Ex_value,'\0',128);
        memset(__value_stmt_rec,'\0',1024);

        if (isc_start_transaction(status, &trans, 1, &DB, 0, NULL))
        {
                printf("Errore\n");
                ERREXIT(status, 1);

        }
        isc_print_status(status);


        if (isc_dsql_allocate_statement(status, &DB, &stmt))
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }
        isc_print_status(status);

        sqlda = NULL;
        sqlda = (XSQLDA *) malloc(XSQLDA_LENGTH(1));
        sqlda->sqln = 1;
        sqlda->sqld = 1;
        sqlda->version = 1;

        if (isc_dsql_prepare(status, &trans, &stmt, 0, selstr, 1, sqlda))
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }
        isc_print_status(status);

        sqlda->sqlvar[0].sqldata = (char *)&long_field_name;
        sqlda->sqlvar[0].sqltype = SQL_LONG + 1;
        sqlda->sqlvar[0].sqlind = &nullind;

        if(isc_dsql_execute(status, &trans, &stmt, 1, NULL))
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }
        isc_print_status(status);

        long_field_name = 0L;

        sprintf(__value_stmt_rec,"%s",value);
        sprintf(__Ex_value,"%s",value);

        while ((fetch_stat = isc_dsql_fetch(status, &stmt, 1, sqlda)) == 0)
        {
                        ;
        }
        isc_print_status(status);


        if( long_field_name ){
                success = 0;
                sprintf(__value_stmt_rec,"%7.7d",long_field_name);

        }
        else{
                success = 1;

        }



        if ( fetch_stat != 100L )
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }


        if ( isc_dsql_free_statement(status, &stmt, DSQL_close) )
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }
        isc_print_status(status);

        if (isc_commit_transaction(status, &trans) )
        {
                printf("Errore\n");
                ERREXIT(status, 1);
        }
        isc_print_status(status);

        sqlda = NULL;
        free(sqlda);

        return success;

}

the problem is 11 minuti for  1600000 select 

do you think is the right time ?

thanks in advance.
Mike