SQL 2005 Express and MX 7 slow?

[Ed Ip]

Hi all,

I am running SQL 2k5 express, MX 7.0.1 on XP Pro SP2. Anyone with similar
setup notice very poor database performance when CF queries the database -- a
query that took milliseconds in SQL2k take upward of 15secs? The performance
issue comes and goes.

The DB performs well on its own against Management Studio Express and other
database tools, but slows to a crawl with CF.

Any suggestions would be greatly appreciated. Thx in advance!

Ed

[Steve Brody]

Hi Ed, are you the former VP Eng at ANDA Networks? I have a client looking to
bring him on board as an outside BoD and would like to get a backchannel check
on him. If so, pls send me an email to me [email]steve@brodyexecsearch.com[/email] or call me
408-741-8900.

Thanks,
Steve

[Steve Brody]

Sorry, I was referring to CEO Charles Kenmore.

[mpwoodward *TMM*]

Ed Ip wrote:

> Hi all,
>
> I am running SQL 2k5 express, MX 7.0.1 on XP Pro SP2. Anyone with similar
> setup notice very poor database performance when CF queries the database -- a
> query that took milliseconds in SQL2k take upward of 15secs? The performance
> issue comes and goes.
>
> The DB performs well on its own against Management Studio Express and other
> database tools, but slows to a crawl with CF.
>
> Any suggestions would be greatly appreciated. Thx in advance!
>
> Ed
>

This doesn't really help you with your problem, but I'm running SQL
Express 2005 on XP SP 2 with CF 7 and it works like a champ. Are you
connecting to SQL Server via localhost or via your machine name? Are
you using the drivers that ship with CF 7? Any firewall or other
security software that might be bogging things down?

As an aside, and this isn't a CF problem specifically, but in SQL
Management Studio I did notice things ran much more slowly if I
connected to my SQL Express instance on my local machine using my
machine name and my domain authentication as opposed to using SQL Server
authentication. It was much faster connecting using SQL Server
authentication.

Matt

--
Matt Woodward
[email]mpwoodward@gmail.com[/email]
Team Macromedia - ColdFusion

[Ed Ip]

Sorry Steve....I am not that Ed. But would have helped you if I could. :)