> We have just moved from a NT server to a Unix server.
>But for some strange reason, there seems to be a considerable time
>difference between NT and Unix. (With CF on Unix accessing a mySQL database)
>I shocked to say I find NT much faster.
>
>That's why I figuring out that there is something that is being done wrong.
>The database is a small one with just over 10,000 records. And for CF to
>take more than
>30 seconds to execute and manipulate the query this i find quite strange.
are these two on the same machine (I wasn't sure from your posting. I am
guessing yes)?. Have you tried using the command line MySQL tools to
connect to the database (thus pulling CF/MyODBC out of the question)? That
brings up another question. You said you are running this in a PPro system.
What OS? I believe the Linux version came with MySQL Drivers installed.
We are running CF (4.5.1)+ MySQL + MyODBC on our Sun box (ok, it does seem
to be a faster machine then what you are running, 2 - 400 MHZ CPU's, tons
of ram). The box really does little work. Usually our connection to the DB
is usually 1 (from testing it from another machine). We have been really
happy with the speed of MySQL both on that server, and on a smaller Linux
server.
benji
---
Benji Spencer
Web Programmer
Moody Bible Institute
312-329-2288
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
