in article abm0q3$ae8$00$2_at_news.t-online.com, shrinad_at_hotmail.com at
aersdjes_at_hotmail.com wrote on 5/12/02 8:20 AM:
> we have the same problem !!
>
> the vantive consultants told use oracle is not working !
>
> so we should extract the data into flatfiles and join them with unix
> shellscripts
>
> we do this daily , grep is much faster than select !!
>
> an informix consultant told us oracle is incredible slow in joining, so
> we should go for access for every client
>
> we tried to improve performance and increased the logbuffer to
> 1000m but it doesn`t help
>
> if you use ramdisk it will work better , but you must export your data
> into flatfiles and print it because if you loose power everything is gone
>
>
> "master-dba" <master-dba_at_aol.com> schrieb im Newsbeitrag
> news:ablm7p$mqd$06$1_at_news.t-online.com...
>>
>> hi,
>>
>> we have vantive 7.0 on oracle 7.1 and we need some help.
>>
>> until know we found that we can get the database from the database
>>
>> select * from sw_customer
>>
>> but we need the data from an additional table
>> we program in vba 2.0 this is very good
>>
>>
>> is something like this possible:
>>
>> select * from sw_customer goto sw_address goto sw_bankaccount goto end
>>
>>
>> why is it so difficult with oracle, dbase was much better and faster
>>
>>
>>
>>
>>
>
>
Troll alert
Received on Sun May 12 2002 - 14:22:33 CDT
