Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search

[REBOL] mysql-protocol

From: tim:johnsons-web at: 26-Jun-2003 7:54

Hello Rebols: DocKimbel and I had an OT exchange of emails early this year in which I posed the the following: That it would be convenient at times for me to have the selection set from a query returned as a 'flat' block. DocKimbel made the following code suggestions: Add 'flat' to locals-class. setting as either 'true or 'false. in 'convert-types change the following line if not empty? convert-body [foreach row rows :convert-body] ;to if not empty? convert-body [ either p/locals/flat? [ row: rows forskip row length? cols :convert-body ][foreach row rows :convert-body] ] After implementing this - if memory serves me well - DocKimbel indicated that he had observed less memory fragmentation in comparison of the two methods. For my own needs, I find it frequently useful to use the 'flat' setting as 'true'. It means that I can use the same block to form a query and to extract the data, easily 'forskip'ing thru the selection set. Sure beats the the python 'dictionary' method. tim -- Tim Johnson <[tim--johnsons-web--com]>