Quick Tip: Storing Session Data

Mark Rusnak is considering using WDDX and creating a packet containing a structure with all of the data needed for the session, stored it in a text field in MS SQL server.

Michael Smith noted that "Storing a WDDX packet in a memo field is a cool idea... but FYI, we have had problems with inserting large text fields into memo fields in SQL server and Oracle. The problem is that the ODBC driver has a limit on how big a single SQL statement can be. This appears to be approximately 16k in our set up and certainly is never greater than 64k.

"This is a problem with the WDDX approach; WDDX makes things about ten times bigger than they were to start with because of all the XML encoding, so with multiple structures, they get big fast!

"If you really need to insert or update large field then the workaround is to loop over them in CF, cutting them up into smaller chunks and updating them onto the end of the field:

UPDATE myTable SET myField = myField & "Next chunk"
WHERE ID=1234

"Hope this helps."

Source: ACFUG mailing list

• Subscribe
• RSS

• Editorial
• Specials
• Community
• News
• Tech and Tags
• Views
• Reviews
• Techniques
• Security
• Best of ColdFusion Talk
• Knowledge Base
• Blog Watch

• Tipical Charlie