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/
 


Reply via email to