Cheers!
Stace
_____
From: Dave Carabetta [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 18, 2004 11:42 AM
To: CF-Talk
Subject: RE: Client Variable Overhead CFMX/CF5
>Hey,
>
>Does anyone know of why a serious performance lapse between ColdFusion
5
>and
>ColdFusion MX exists when using a Database to store Client Variables.
In
>CF5
>we found no real performance degredation from using DB over Registry.
>
>In MX when using the Registry parsing completion is around 0-16ms but
when
>switched to a DB it can bloat to over 2000ms...
>
>This is ONLY for the cfapplication tag within an Application.cfm
template.
>
>Querying the DB directly via QA has no performance lapse at all.
>
Have you tried testing against CDATA and CGLOBAL tables with indexes on
the
CFID column? We did that (along with changing the column type from CHAR
to
VARCHAR2 (VARCHAR in SQL Server) and were able to see some nice
performance
gains.
I know that doesn't directly answer your question, but I figured you'd
might
want a potential solution because there's nothing we can really do about
it!!
Regards,
Dave.
<table width=800 cellpadding=4 cellspacing=10 border=0><tr bgcolor=BDBDBD><td valign=top width=400><font face=verdana size=2 color=FFFFFF><b>AVIS IMPORTANT</b></font></td><td valign=top width=400><font face=verdana size=2 color=FFFFFF><b>WARNING</b></font></td></tr><tr><td valign=top width=400><p align=justify><font face=verdana size=1 color=808080> Les informations contenues dans le present document et ses pieces jointes sont strictement confidentielles et reservees a l'usage de la (des) personne(s) a qui il est adresse. Si vous n'etes pas le destinataire, soyez avise que toute divulgation, distribution, copie, ou autre utilisation de ces informations est strictement prohibee. Si vous avez recu ce document par erreur, veuillez s'il vous plait communiquer immediatement avec l'expediteur et detruire ce document sans en faire de copie sous quelque forme.</td><td valign=top width=400><p align=justify><font face=verdana size=1 color=808080> The information contained in this document and attachments is confidential and intended only for the person(s) named above. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution, or any other use of the information is strictly prohibited. If you have received this document by mistake, please notify the sender immediately and destroy this document and attachments without making any copy of any kind.</td></tr></table>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
