Ask a Question related to Coldfusion Database Access, Design and Development.
-
AdamK #1
CF 5 generating slow DB queries
We are using CF 5 against Oracle DB (9.2.0.5) when running snapshots of the
Database we see lots of queries generated by cfserver.exe which are obviously
generated internally by CF and are taking lots of CPU time. how are these
generated? is this the internal implementation of CFUPDATE/CFINSERT ? how can
we make CF stop doing this? here's an example ------------------------- select
to_char(null), ac.owner, ac.table_name, acc.column_name, acc.position,
ac.constraint_name from all_constraints ac, all_co ns_columns acc where
ac.owner=acc.owner and ac.constraint_type= 'P' and
ac.constraint_name=acc.constraint_name and ac.table_nam e like 'CUSTOMER'
escape '\'
AdamK Guest
-
Slow queries when using myODBC with ASP pages
Hi, I have a website hosted on two servers bi-xeon(Win2003, 1GB RAM) : one for the website, one for MySQL 4. I access MySQL from my ASP Pages... -
Microsoft SQL Server w/SP4 and parameterized decimalfields in queries causes slow downs.
Yesterday, my company upgraded our database (Microsoft SQL Server 2000) to service pack 4. Today, we started observing queries were taking much... -
slow queries from CF 5 to CF 7
I am transferring from CF 5 to CF 7. I moved one site, and I noticed that on CF 5, with an Access DB as the datasource, the page takes 20 ms total... -
Queries Of Queries Single Quote Problem
When using queries of queries I'm having the following issue. Select Company_ID From qry_MyQuery Where Company_NM = 'MyString''s' <----... -
Slow Queries with Linux/Oracle
I have a query in CF7 hitting a Linux/Oracle server that takes 80,000 milliseconds to run, while the same query run in TOAD take 37 milliseconds....



Reply With Quote

