>Hi,
>
>1- SANDMAR is a huge business retails Project
>2- 157000 records i need it a live
>
>look when i made one link just between all tables its become OK, but the result was wrong. all what i need is how can i increase the speed or is there are away without remote view like what if i made a PRG File it will be ok to increase the speed and how ?
> thanks For Time

Remote views are slow. Pass through cursors that only collect data necessary for the current process are much faster. Build "little" cursors that are only important for the current process. Read what you need and then write back what you need.