Re: oracle access in vantive

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
>
>
>
>
>
Received on Sun May 12 2002 - 10:20:49 CDT