Hi
I have a performance problem in the inventtable form. When I run Axapta in 2-tier, the form is loaded quickly but not when I run Axapta in 3-tier thin. I can see that there is a difference in the select statement sent to the SQL. In 2-tier the select includes an 'First rows' parameter, but that is not the case in 3-tier. In 3-tier it seems to find all records that satisfy the select statement. How do I change the select statement or how do I speed up performance in this case? thanks Irving ------------------------ Yahoo! Groups Sponsor --------------------~--> $9.95 domain names from Yahoo!. Register anything. http://us.click.yahoo.com/J8kdrA/y20IAA/yQLSAA/kGEolB/TM --------------------------------------------------------------------~-> Sharing the knowledge on Axapta. Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/