Stored Proc Performance vs CFusion

-

i'm relatively more experienced sql , variety of reasons discussed elsewhere (performance, security, portability html/flex , mvc code organization) building app more cfcs , stored procedures.

that said, initial iterations <cfquery> based, have moved relatively simple procedure (which sets , feel home page depending on visitor ip)

<cfquery>
to
<cfinvoke> cfc <cfstoredproc> mysql 5.1 stored procedure

long story short, works latter taking longer load (exact same data exact same devserver machine both cf8 , mysql on it) significant factor (probably 100 times).

any thoughts on why? (fwiw server p4 800 mhz 1.5 gb ram)

> <cfquery>
>
> <cfinvoke> cfc <cfstoredproc> mysql 5.1 stored procedure

you're doing 2 operations in latter compared 1 in former.
how apples-n-apples compare: cfquery vs cfstoredproc (eliminating
the cfinvoke purposes of testing)? version of cf on?
cf's traditionally been pretty slow instantiate cfcs (it's getting ok @
it, in cf8).

what on subsequent hits same code, same parameters?

i've found - dismay - cf or jdbc bit slow
with oracle stored procs, compared same db processing being done in
a cfquery. relatively simple stuff, anyhow. none of procs more
than 50-or-so statements long.

i can't vouch mysql. haven't used since v3.x.

--
adam


More discussions in ColdFusion


adobe

Comments

Post a Comment

Popular posts from this blog

Convierte tu Raspberry en un NAS. Firmware fvdw-sl 15.3 - Raspberry Pi Forums

-
¿conocéis este proyecto? fvdw-sl 15.3 para raspberry pi. convierte la raspi en un nas. http://plugout.net/viewtopic.php?f=31&t=1880 llevo tiempo intentando encontrar la forma de hacer que una de mis raspberry se comporte como un nas. configurando samba, minidlna, transmision, ftp, nfs, etc. pues con esta distribución lo tengo todo hecho. lo instalé ayer y me tiene soprendido. ahora mi raspi es un nas, hecho y derecho. caracterísitcas. - interfaz web. que cambia en función de si eres el administrador o un usuario. - gestión de usuarios. puediendo dar distintos permisos carpetas y funciones. - gestión de carpetas - vpn - ftp - nfs - webdav - varios servidores dlna como minidlna, townky, etc - varios gestores de descarga como transmision, mldonkey, etc - gestión de periféricos usb como impresoras o webcam. - gestión de cron para automatizar procesos. - creo que se basa en arch linux. por cierto, estoy creando una tarea para que me exporte un archivo txt del dis...
Read more

How to format a Get Request

-
i have external server running mysql. have installed php script that, when accessed http deliver data 1 of tables. works fine browser: code: [select] http://www.seti.net/php/getevents.php i cannot figure out how send command arduino. have ethernetclient library working , can access google in example. when send command through client: code: [select] client.println("//get /php/getevents.php http/1.0"); the server returns: code: [select] </head><body> <h1>method not implemented</h1> <p>get /php/getevents.php not supported.<br /> what correct way format in arduino? i use send temperature web server. note lack of http version , additional blank line after - not sure whether difference important works: code: [select] void  sendtemptoserver() { char getrequest[80]; if (client.connect(server, 80))   {   sprintf(getrequest,"get /cgi-bin/arduino.cgi?reading=%s&arduino_id=23&sensor_id=1",t...
Read more

avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62

-
hello, im confused uno r3, uploaded code quite few months in uno, working fine. now without having altered of circuits, trying upload code changes,im getting strange error "avrdude: verification error, first mismatch @ byte 0x0000          0x0c != 0x62" i tried research able solve issue,  im running kind of fuse bit being changed or clock speed altered, im pretty sure did not play around these items. any people, please . . thanks taz Arduino Forum > Using Arduino > Installation & Troubleshooting > avrdude: verification error, first mismatch at byte 0x0000 0x0c != 0x62 arduino
Read more