Query Large Data
I have 2 table
1. Stock (codestock (PK), name)
2. Warehouse (codewarehouse,codestock,amount)
I want to select from stock and warehouse, each table have 12000 records.
I use simple query like this
"select * from stock s, warehouse w where s.codestock=w.codestock"
I use in delphi 2006 with zeos component. This query very slow to show the 12000 records in dbgrid
How to select those table really fast?
Subject
Written By
Posted
Query Large Data
December 18, 2008 02:47AM
February 05, 2009 06:25AM
February 03, 2009 08:03AM
February 05, 2009 06:26AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.