Hi all
2 questions:
yesterday i need to reinstall CF MX 6.1 after 3 months works fine...
Today when run this script:
<!---get MaxID form DB--->
<cfloop condition="true">
<cftry>
<cftransaction>
<cf_max_ID
datasource="#dsn#"
tablename="tblNews"
primarykey="intNewsID">
<cfquery name="atualiza_db" datasource="#dsn#">
INSERT INTO tblNews(
intNewsID,
strSiteID
)
VALUES(
#max_ID#,
'Trim(Session.Auth.strSiteID)'
)
</cfquery>
</cftransaction>
<cfbreak>
<cfcatch type="database">
</cfcatch>
</cftry>
</cfloop>
CF MX hangs CPU and increase RAM again and again.... What's happened?
--------
How to improve performance with MySQL DB?
Thanx in advance
--
_______________________________________________
Get your free email from http://www.mail.com
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
- Re: CF_MAX_ID - MySQL slowww Spectrum WebDesign
- Re: CF_MAX_ID - MySQL slowww Jochem van Dieten
- RE: CF_MAX_ID - MySQL slowww Barney Boisvert
- RE: CF_MAX_ID - MySQL slowww Spectrum WebDesign
- RE: CF_MAX_ID - MySQL slowww Barney Boisvert
- Re: CF_MAX_ID - MySQL slowww Jochem van Dieten
- RE: CF_MAX_ID - MySQL slowww Barney Boisvert
- Re: CF_MAX_ID - MySQL slowww Jochem van Dieten
- RE: CF_MAX_ID - MySQL slowww Barney Boisvert
- Re: CF_MAX_ID - MySQL slowww Jochem van Dieten
- RE: CF_MAX_ID - MySQL slowww Matt Robertson