高手,吐血問題..... Online Waiting (189分)

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #1

我是對兩個dbf文件,通過key field 關聯.mater table create lookup field to link detail table 然後,將master table 顯示在dbgrid 中.
然後將master table 導出到 excel 中 紀錄超過10000條
解決方法要速度快.
到處數據時好像down 機 ,太慢.dbgrid 跳動.一會兒.不動了.太慢?
惱死了.

 

W

wangjiankang

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #2

DBF性能不好，你考虑换数据库产品或取消自动的主从表，改用手动，
几显示主表DBGRID，在DBGRID控件上写事件代码，动态形成子表查询语句，检索记录并显示

 

T

twos

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #3

最好不要使用m/s这种关联的方式
自己处理，可能会快一点
不过dbf不适合大数据量的，可以录入几十万条数据，但是select就困难了

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #4

我用前面幾個仁兄的方法.ado+query+excel 到出數據很快
問題是;
master table 中的 key field 的紀錄要比 detail table 的 多,
如;
master table :
emp_no f_name
001 aa
002 bb
003 cc
004 dd
detail table:
emp_no salary
001 11111
002 22222
004 44444

i want to export table
emp_no f_name salary
001 aa 11111
002 bb 22222
003 cc
004 dd 44444

用 query 該怎樣寫呢? on line waiting !!!

 

T

Traveller

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #5

导出的时候把Datasource Disable掉，这样就不会引起数据敏感控件的更新，速度就会快不少。

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #6

級位仁兄把分數分了吧!

 

T

Traveller

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #7

问题是你的问题解决了没有？如果没有解决我们怎么好意思急着要分呢？

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #8

DISABLECONTROL NO USE PERHAPS FASTER BUT NO SENSE .WAITING AND WAITING.[][][8D]
OK, I HAVE TO USE CONTROL TO DO IT .
DO YOU KNOW WHAT I MEAN ? LOOK UP !!![8D]
I HOPE WE COULD RESOLVE IT .THIS EVENING ,I TRY IT .

 

T

Traveller

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #9

看来现在的瓶颈可能在DBF上了，另外，建议你试试直接往Excel里面插入10000多条数据，估计这方面也有不小的影响。

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #10

2000-3000 perhaps faster[8D] .10000 died[][8D]
i think i have to split the dbf data into pieces.perhaps ok ? let me test.
thanks[8D].

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-11

• #11

我已經解決了這個問題.
道出數據特別快.10000條紀錄不到5秒鍾

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #12

我用前面幾個仁兄的方法.ado+query+excel 到出數據很快
問題是;
master table 中的 key field 的紀錄要比 detail table 的 多,
如;
master table :
emp_no f_name
001 aa
002 bb
003 cc
004 dd
detail table:
emp_no salary
001 11111
002 22222
004 44444

i want to export table
emp_no f_name salary
001 aa 11111
002 bb 22222
003 cc
004 dd 44444

用 query 該怎樣寫呢? on line waiting !!!
use outer join ?[?][8D]

 

F

fwcy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #13

这样写：
with query1 do
begin
close;
sql.Clear;
sql.Add(select (master table).emp_no,(master table).f_name,
(detail table).salary from (master table)');
sql.Add('left outer join detail table');
sql.Add('on (master table).emp_no=(detail table).emp_no');
prepare;
open;
end;

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #14

thanks!!!
i will give some scores to all of experts.[8D][8D]

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #15

problem: [?]i have an excel file include some sheets. and each sheet owns some material_No
fields and a dbf file include all material_No fields and other items.[?]

answer[8D] is an excel file that include sheets .each sheet owns this dbf file's other
items include same material_no.[8D]

what can i do ?

what you think is same important to me .

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #16

[8D]謝謝!!![8D][8D]
得分了[]

 

D

dragonlee007

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-10-12

• #17

i do it myself !!
thanks a lot !!!