Another small optimization: If you only use the name field in your TableBuffer you should only select that field
While select Name from tb { .... } -----Original Message----- From: Axapta-Knowledge-Village@yahoogroups.com [mailto:[EMAIL PROTECTED] On Behalf Of mohit rajvanshy Sent: 20. december 2005 07:31 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] Performance Issue Hi All, I am trying to fetch the records from a table which is having 30,000 + records. I am concatenating the string. But it is taking too much time for this operation. Any better idea to perform this operation ? TableBuffer tb; str a; ; while select tb { a = a + tb.name; } Thanks in advance Mohit Regards Mohit Rajvanshy __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com Sharing the knowledge on Axapta. Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> $15 provides a child with safe, clean water. Your gift can make a difference. http://us.click.yahoo.com/vp8GxB/icGMAA/cosFAA/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/