Re: Delphi TTable-component

Hi Hans,
In my knowledge TTable is optimized for using Paradox tables and other non sql based db engines such as Access, DBase etc... You should use a TQuery control instead which is optimized for SQL based tables such as MS-SQL, Oracle, Interbase etc...

Anyway, I used Delphi since version 1 and I ended up one of the best Development languages to be used when handling with SQL RDBMS is Powerbuilder (which compared to Delphi has a terrific frontend and editor but on the database side is much better)

Best Regards.

• ALEX ****

> Dear Oracle admirers,
>
> I'm facing a strange problem :
>
> I'm an expirienced Delphi programmer but an Oracle newbie !
> I have a large table with 200,000 records. I do have a primary key on the
> field 'ID',
>
> When I use a TTable-component and set IndexfieldNmaes to that 'ID', it takes
> a very, very long time to find the record with ID equal to 150,000.
> When I don't put anything into the property IndexFieldNames it only takes a
> part of a second to find the same record.
>
> Two questions :
> - I do use the correct index : why does it take so long when I really
> specify the key ?
> - In general : I'm using Delphi 4. Should I use TTable or TQuery ? Any white
> papers on this subject ?
>
> Thanks for your reply.
>
> H.
Received on Sun May 09 1999 - 23:34:06 CEST