Re: Delphi TTable-component

Hi,

The delphi TTable is made to use with dBase/Paradox tables. For Oracle and other client/server systems it is much better to use TQuery and TStoredProc.
If you use TTable all the searching for de right data is be done on the client machine, it's like select * from mytable. If you use a good sql statement in a TQuery the server sends only the small dataset you askt for. like:
select Field1, Field2 from mytable
where ID = 150000
don't worry about indexes in your delphi application, Oracle chooses the best index itself. (of course the must be available on de database) Use TStoredProc for functions and procedures in your database.

Chris

Hans Demedts heeft geschreven in bericht <7gfdfn$j10$1_at_news1.skynet.be>...
>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 Tue May 04 1999 - 03:25:42 CDT