There is no big performance difference between the two methods.

I would put my concentration on how to create your tables based on your display query.
For instance
if your display query is like following

select table1.col1 || table2.col2
from table1,table2
where table1.col1='xxx' and table2.col2='yyy'

you should create indexes for table1.col1 and table2.col2 when you create tables.
There is a huge difference in performance if you don't do that

所有跟帖： 

• that't it. Indexes make a big difference , especially for the h -戏雨飞鹰- ♀ (0 bytes) () 10/10/2008 postreply 11:17:26

• especially for the huge tables -戏雨飞鹰- ♀ (0 bytes) () 10/10/2008 postreply 11:17:54

• 看来这课没白上~~ -澳洲老土- ♂ (0 bytes) () 10/10/2008 postreply 15:05:33