A breadcrumb array kept in the session scope has been key. Stores everything
the
does and gets dumped to the error file.
Am curious as to what you did there. Would you mind sharing how you did that? (
I dont need code ) just your idea(s) explained with some more detail.
You can also configure CF to log slow pages and if you have enterprise,
server monitor can log/alert you to slow/hung requests.
On 12/2/14, 10:52 AM, Money Pit wrote:
Another good suggestion. But I'm not recieving much in the way of information
from the host anymore. Seems they might not
Sounds like it's time to move on.
On 12/2/14, 1:11 PM, Don wrote:
I'm not recieving much in the way of information from the host anymore. Seems
they might not like me poking around too much I dont know.
~|
Order the
Sounds like it's time to move on.
On 12/2/14, 1:11 PM, Don wrote:
I'm not recieving much in the way of information from the host
anymore. Seems they might not like me poking around too much I
dont know.
lol, well that's exactly what the developer of their e-commerce software
Sounds like they need a new host. Is that an option?
On Tue, Dec 2, 2014 at 4:33 PM, Don danfar...@hotmail.com wrote:
Sounds like it's time to move on.
On 12/2/14, 1:11 PM, Don wrote:
I'm not recieving much in the way of information from the host
anymore. Seems they might not like me
FR is indeed meant to run on a production server, and I was not saying
otherwise.
But you can also install it on dev to help you with the debugging and load
testing as well.
I think you are incorrectly assuming that FusionReactor is a debugging and
load testing tool, which is not the case. FR is
If I had to diagnose this, I would start with making sure that none of
the function calls or cfinvokes are endlessly recursing. Then I would
make sure none of the database queries are hanging.
On Thu, Nov 27, 2014 at 9:03 PM, Don danfar...@hotmail.com wrote:
Got this custom e-commerce app
Russ Michaels wrote:
I think you are incorrectly assuming that FusionReactor is a debugging and
load testing tool,
No not at all. Thats why I called it a 'diagnostic reporter' earlier on.
Something I don't need at all for the most part but need desperately when
things aren't going right and
Great!
And these sessions structures, do you write the data to the DB onSessionEnd ?
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
No I don't. It all sits in memory unused. But if an error occurs this
info gets dumped out via my error handler where it can be used
post-mortem. Generally my error handler loops over a pre-defined list of
scopes and dumps them all out. Depending on the setting I've made, the
dump is either
No I don't. It all sits in memory unused. But if an error occurs this
info gets dumped out via my error handler where it can be used
post-mortem. Generally my error handler loops over a pre-defined list of
scopes and dumps them all out. Depending on the setting I've made, the
dump is either
I run a financial service site that has very complex pathways running
through it. This has saved me an enormous amount of time trying to figure
out how a series of user actions could uncover some sort of hole in the
code.
This thread got me tinkering and I did some tweaking. For starters when
I suspect Russ meant, replicate your production environment locally and
do your diagnostics, load testing, and performance tuning on a testing
server before deploying your changes to production.
Another vote for moving to your own VPS. They're cheap these days and
totally worth it.
On
doing debugging and load testing on a live production server is generally a
bad idea.
You are meant to do this in a dev or staging environment, usually you do
this before going live to emulate production environment and traffic and to
find any issues
There is absolutely no restrictions whatsoever
Hi folks. I have noticed one or two backend processes that seem to bring the
FREE JVM Memory down.
I noticed a sharp drop in JVM memory during this process ( it all happened in
about one minute )
Say from the average JVM Freememory of : 255 Megs
Dropping to around : 30 Megs
For a moment,
This could be a case of another site on the server bringing it down and not
your site.
Byron Mann
Lead Engineer Architect
HostMySite.com
Ah yes. Very logical deduction. Thank you Sir.
~|
Order the Adobe Coldfusion Anthology
There is absolutely no restrictions whatsoever on where FR can be
installed, it would be pretty useless if that was the case, you can install
it on any supported OS, FR does not know or care what you are using that
machine for.
So how does that work then? You point FR to a domain? i thought it
He means you can install it on your production, testing, or dev server
or whatever.
On 12/1/14, 9:25 PM, Don wrote:
There is absolutely no restrictions whatsoever on where FR can be
installed, it would be pretty useless if that was the case, you can install
it on any supported OS, FR does
Does anyone know of any supposed issues with CF 11 and cfqueryparam ?
I had a few of them in a query. One by one I removed them to see if I could
get the
query working and then, adding them in. All but one work.
Any ideas?
You need to provide more information. Did the query work with CF
The errors getting back are all The request has exceeded the allowable time
limit Tag
Seems that the whole server eventually crashes/slows to crawl, even though
other websites on that same server are fine.
CF Version 11 / SQL Server Express
Looking at the JVM free memory, it always seems to
Does the line number on that error indicate that the query is what's timing
out?
On Fri, Nov 28, 2014 at 11:46 AM, Don danfar...@hotmail.com wrote:
The errors getting back are all The request has exceeded the allowable
time limit Tag
Seems that the whole server eventually crashes/slows to
The errors getting back are all The request has exceeded the allowable time
limit Tag
What's happening on the database server?
Have you stopped and restarted the database server? Have you disabled
and reenabled the Maintain Connections option in your database
driver?
Dave Watts, CTO, Fig
I suggest installing fusionReactor and monitoring your local cfserver.
Run some performance/load testing on the app and see what happens, it
should you what pages are having issues
Run cfdebugger on those pages
Russ, on our host installing this is not possible right now.
is there anything else
Just using the builtin server monitoring in CF Enterprise was pretty
helpful to me to find the slow/hung requests. After optimizing those
things got better but ultimately moving from CF9 to CF11 on a new box
solved our crashing issues.
On 11/28/14, 10:01 AM, Don wrote:
I suggest installing
Sounds like you are on a shared server if the host cannot, install
something to your liking.
This could be a case of another site on the server bringing it down and not
your site.
Byron Mann
Lead Engineer Architect
HostMySite.com
You don't do it on the host, you do it locally
On Fri, Nov 28, 2014 at 18:01 PM, Don danfar...@hotmail.com wrote:
I suggest installing fusionReactor and monitoring your local cfserver.
Run some performance/load testing on the app and see what happens, it
should you what pages are having
Does anyone know of any supposed issues with CF 11 and cfqueryparam ?
I had a few of them in a query. One by one I removed them to see if I could get
the query working and then, adding them in. All but one work.
Any ideas?
Were you getting an error?
On Thu, Nov 27, 2014 at 3:08 AM, Don danfar...@hotmail.com wrote:
Does anyone know of any supposed issues with CF 11 and cfqueryparam ?
I had a few of them in a query. One by one I removed them to see if I
could get the query working and then, adding them in. All
Hi,
I'm running some tests on tag cffileupload.
Some labels, like Add Files, Clear All... can be supplied in different
language in attributes, but some others, like File Name, Size (KB), ...
cannot.
Has someone find a way to completely localize the tag?
Thanks.
Got this custom e-commerce app that is basically going down daily.
Seems to run fine again upon server restart, but eventually it goes down to a
crawl.
This started happening after some patches to Coldfusion 11 were implemented.
Host says it was rolled back, but problems are persisting.
I'm
I suggest installing fusionReactor and monitoring your local cfserver.
Run some performance/load testing on the app and see what happens, it
should you what pages are having issues
Run cfdebugger on those pages
On Fri, Nov 28, 2014 at 2:03 AM, Don danfar...@hotmail.com wrote:
Got this custom
I suggest installing fusionReactor and monitoring your local cfserver.
Run some performance/load testing on the app and see what happens, it
should you what pages are having issues
Run cfdebugger on those pages
Cheers Russ. Been out of the game for a while, but now I'm headlong in. Glad to
see
Probably due to the poodle vulnerability and the disabling of ssl 3. Update
to Java 1.7 and you should be good.
On Tuesday, November 25, 2014, Donnie Carvajal
donnie.carva...@transformyx.com wrote:
Thanks for the feedback. I am having issues updating Java. I've updated to
HotFix 3 and
Look at your log files for what the actual error on startup might be.
C:\ColdFusion9\logs\
I would care to guess to look in the server.log file
John Blayter
m: 303.325.1979
http://www.blayter.com/john/
On Wed, Nov 26, 2014 at 8:37 AM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:
Look at your log files for what the actual error on startup might be.
C:\ColdFusion9\logs\
I would care to guess to look in the server.log file
John Blayter
m: 303.325.1979
http://www.blayter.com/john/
On Wed, Nov 26, 2014 at 8:37 AM, Donnie Carvajal
donnie.carva...@transformyx.com wrote:
Donnie,
That's the wrong log location. You need to look in the standard out log. In
a typical install (non multiserver) it would be in
/coldfusion9/runtime/logs/ look for cfusion-out.log
-Mark
-Original Message-
From: Donnie Carvajal [mailto:donnie.carva...@transformyx.com]
Sent:
Hi,
I just started receiving the following error for a java API that we are using
to connect to Netsuite.
javax.net.ssl.SSLHandshakeException: sun.security.validator.ValidatorException:
PKIX path building failed:
sun.security.provider.certpath.SunCertPathBuilderException: unable to find
It certainly could be a failed intermediate certificate. See this post from
yesterday Donnie. Lots of certs changes in the wild right now.
http://www.coldfusionmuse.com/index.cfm/2014/11/24/coldfusion-tsl-ssl3-JVM-1
-7
Mark Kruger - CFG
CF Webtools
www.cfwebtools.com
www.coldfusionmuse.com
There's a -7 at the end of that link as in JVM-1-7 .. sorry about the
wrap. (saying that makes me want to beat box for some reason).
-Original Message-
From: Mark A Kruger [mailto:mkru...@cfwebtools.com]
Sent: Tuesday, November 25, 2014 12:04 PM
To: cf-talk
Subject: RE: Java
Probably due to the poodle vulnerability and the disabling of ssl 3. Update
to Java 1.7 and you should be good.
On Tuesday, November 25, 2014, Donnie Carvajal
donnie.carva...@transformyx.com wrote:
Hi,
I just started receiving the following error for a java API that we are
using to
http://flint.com.sg/ttzkvsqa/nmuissclqzjwevfvsgfdbyiynvkq.irdrnsvmxqelzylc
Matthew Allen
~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Here was a JDBC driver that I found that supposedly works with FoxPro,
StelsDBF (http://www.csv-jdbc.com/stels_dbf_jdbc.htm). I've never used them
before, but they have a demo version of the driver that you can download.
On Fri, Nov 21, 2014 at 7:58 PM, Arden Weiss ardenwe...@verizon.net wrote:
Doug,
I've reached out to Gavin to give him a copy of the installer (I have
the Update 1 version of the Windows installer). It's 32-bit only (there
was no 64-bit installer for CFBuilder 2).
I'll send you a direct email with a ling to my Dropbox folder where I
have a copy.
-Carl V.
On
You may also want to try the driver by HXTT (http://www.hxtt.com/dbf.html).
I use their Access driver to be able to work with some of my old Access
driven projects on my Mac.
On Mon, Nov 24, 2014 at 9:28 AM, Dean Lawrence dean...@gmail.com wrote:
Here was a JDBC driver that I found that
Arden,
You may be able to bridge to an ODBC DSN. The issue is typically 64bit vs 32
bit but it can usually be overcome - at least on Win2008r2. We've done this
with Access and MS text drivers but never with fox pro - still, the process
should be about the same I think.
-Mark
-Original
Hi Folks
I would affirm kickAssVps, I was with them for several years and got great
responsive service.
However for business reasons, which I totally understand, they are not
upgrading to CF11.
I moved to www.viviotech.net/ and because I am not all that literate in the
server and condfusion
They have CF11.
Rick
-Original Message-
From: Rob Voyle [mailto:robvo...@voyle.com]
Sent: Friday, November 21, 2014 2:43 PM
To: cf-talk
Subject: Re: need a host
Hi Folks
I would affirm kickAssVps, I was with them for several years and got great
responsive service.
However for
I should really get to know these KickAssVPS people. They are located less than
2 miles from my house here in St. Paul, MN.
Wil Genovese
Sr. Web Application Developer/
Systems Administrator
CF Webtools
www.cfwebtools.com
wilg...@trunkful.com
www.trunkful.com
On Nov 21, 2014, at 2:57 PM,
I would highly recommend them, without reservation.
I have no vested interest in a recommendation. They've just been
great to work with since I placed my first VPS order in 2008 and have
been very helpful, supportive, and accommodating.
I just have them set up my VPS's and then manage the
Ha! Kinda funny... This is a Virtual server, and I manage the
hardware! :)
On 11/21/2014 4:09 PM, Rick Faircloth wrote:
I would highly recommend them, without reservation.
I have no vested interest in a recommendation. They've just been
great to work with since I placed my first VPS order
Hi all -
I just had my laptop reimaged and one of the items I am missing is the
CFbuilder2 installer package. I have my serial... just need the
installer. If anyone has it, I would appreciate it if I could get a copy.
I tried to find it on adobe's site, but since 3 rolled out, I've had no
http://www.gpickin.com/cfrepo/
-Carl V.
On 11/21/2014 2:28 PM, Doug R wrote:
Hi all -
I just had my laptop reimaged and one of the items I am missing is the
CFbuilder2 installer package. I have my serial... just need the
installer. If anyone has it, I would appreciate it if I could get
Thanks Carl - great resource. Unfortunately, though, there is only the Mac
(.dmg) installer. I should have specified that I need a windows installer
(don't recall if it comes in 32 and 64 bit flavors - 64 bit preferred).
If anyone has a copy of the windows installer, I'd love to get a copy,
Need advice on what database drivers work well with CF10 and the old FoxPro for
DOS DBF files. Back in the CF
Client has app that has been running flawlessy since 2000 or so using CF5 and
the ODBC drivers that came with the product to process credit card transactions
via authorize.net -- back
I've always gotten quick, personal attention to any issues that may arise.
On 11/19/2014 9:27 PM, Rick Eidson wrote:
I posted about this last week... Yes, you are right. It seems they have
become a bit drone like. Before with a tech problem things seems more
personable.
Rick
+1 for KickAss. They've always been very responsive for me.
On Thu, Nov 20, 2014 at 9:39 AM, Rick Faircloth r...@whitestonemedia.com
wrote:
I've always gotten quick, personal attention to any issues that may arise.
On 11/19/2014 9:27 PM, Rick Eidson wrote:
I posted about this last
Same here, no complaints with Hostek service or support at all.
On Nov 20, 2014 9:39 AM, Rick Faircloth r...@whitestonemedia.com wrote:
I've always gotten quick, personal attention to any issues that may arise.
On 11/19/2014 9:27 PM, Rick Eidson wrote:
I posted about this last week...
I know it can be re-created but for us lazy ones on the list would you be
willing to share the Carrier to domain table?
Dennis Powers
UXB Internet - A website Design and Hosting Company
P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844
W: http://www.uxbinternet.com
W:
Verizon: vtext.com
Nextel: messaging.nextel.com
Sprint: messaging.sprintpcs.com
Cingular: cingularme.com
Virgin Mobile: vmobl.com
T-Mobile: tmomail.net
On Thu, Nov 20, 2014 at 8:54 AM, UXB Internet denn...@uxbinternet.com wrote:
I know it can be re-created but for us lazy ones on the
Yes...you got it Rick
Another decision point for you is this...
Are you intending on just sending out texts? or also receiving?
If receiving is that part of a conversation (i.e. they send you a
start code, you ask a question, they provide an answer and so on). If
you are looking at that
Not always an XML packet - Clickatel and their HTTP API uses CFHTTP with
basic params - no XML
*Bryan Stevenson*B.Comm.
President CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com
I've worked quite a bit with Twilio for sending and receiving text messages
in CF: https://www.twilio.com/ they have a REST api, that is pretty easy to
use: https://www.twilio.com/docs/api/rest/sending-messages
--
Pete Freitag - Adobe Community Professional
http://foundeo.com/ - ColdFusion
if you are on a shared server then it would be an issue for others who are
using SOLR, which would then require the host to roll back to 1.6, which
would then cause your problem again.
Judging by the fact that you said you had to convince them to do this, I
assume it is a shared server, otherwise
Like Pete, I've used Twilio's services, though it's most useful if you're
also receiving SMS messages. It's been a long time since i used them, but
if you decide to do so, I probably have some old code that might get you
started.
But if you're only sending, never receiving, the email-to-text
In my scenario, it's my user who wants my website to send them a text.
So, someone signs up for text alerts from my site, I ask them for
their number and carrier, and then I can just email to their number +
carriers domain and it's converted to a text.
On Tue, Nov 18, 2014 at 4:31 PM, Rick
I appreciate your feedback Russ. Thank you. From what I've read there does
seem to be a fix to the broken SOLR collections. Have you seen this?
On Wed, Nov 19, 2014 at 10:20 AM, Russ Michaels r...@michaels.me.uk wrote:
if you are on a shared server then it would be an issue for others who are
no I haven't seen it, I even emailed Adobe about it directly and got no
reply
On Wed, Nov 19, 2014 at 9:49 PM, Michael Grant mgr...@modus.bz wrote:
I appreciate your feedback Russ. Thank you. From what I've read there does
seem to be a fix to the broken SOLR collections. Have you seen this?
This is the Adobe bug report about Solr breaking with Java 1.7.0_51 and higher
when sandboxes are enabled. This was just fixed in Update 14 for CF10.
Wil Genovese
Sr. Web Application Developer/
Systems Administrator
CF Webtools
www.cfwebtools.com
wilg...@trunkful.com
www.trunkful.com
On
So sorry to bring up an old thread. BUt things have changed at Hostek.
Simple common sense have changed into support phone scripts,
unresponsive tickets, beuracy over account confirmatino over the
phone.
Some examples:
EXAMPLE 1:
Me: Hi Can you make this change on the account since the online
were on CF9
On Thu, Nov 20, 2014 at 12:16 AM, Wil Genovese jugg...@trunkful.com wrote:
This is the Adobe bug report about Solr breaking with Java 1.7.0_51 and
higher when sandboxes are enabled. This was just fixed in Update 14 for
CF10.
Wil Genovese
Sr. Web Application Developer/
KickAssVPS.com
Been with them for years; very little trouble; always quick with support.
They even tailor VPS's for me.
On 11/19/2014 7:49 PM, Brian Thornton wrote:
So sorry to bring up an old thread. BUt things have changed at Hostek.
Simple common sense have changed into support phone
I posted about this last week... Yes, you are right. It seems they have
become a bit drone like. Before with a tech problem things seems more
personable.
Rick
-Original Message-
From: Rick Faircloth [mailto:r...@whitestonemedia.com]
Sent: Wednesday, November 19, 2014 7:41 PM
To:
I'll make a recommendation here that may or may not apply, but may be worth
noting. This is assuming ms sql Server.
Insert...values...
Insert...values...
, n
Will be much slower from SQL perspective than:
Insert...
Values(...)
, (...)
, (...)
, n
Or
Begin tran
Insert... Values...
Insert...
I finally have an update here. After much back and forth and having to
REALLY make a case for why I was able to convince Newtek to update their CF
servers to run Java 1.7 instead of 1.6. This had an immediate positive
result and the SSL handshake was able to proceed properly with TLS.
Thanks to
did you check if SOLR still works after the upgrade ?
On Tue, Nov 18, 2014 at 3:00 PM, Michael Grant mgr...@modus.bz wrote:
I finally have an update here. After much back and forth and having to
REALLY make a case for why I was able to convince Newtek to update their CF
servers to run Java
did you check if SOLR still works after the upgrade ?
Doesn't Solr use a separate JVM?
Dave Watts, CTO, Fig Leaf Software
1-202-527-9569
http://www.figleaf.com/
http://training.figleaf.com/
Fig Leaf Software is a Service-Disabled Veteran-Owned Small Business
(SDVOSB) on GSA Schedule, and
no it uses the one that comes with cf. I have tried switching solr to 1.7 as
well, same issue
Sent from Windows Mail
From: Dave Watts
Sent: âTuesdayâ, â18â âNovemberâ â2014 â22â:â02
To: cf-talk
did you check if SOLR still works after the upgrade ?
Doesn't
Running a page that reads a text file into an array - then writes the
array to the database.
I get the following error:*
Detail:* [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming
tabular data stream (TDS) remote procedure call (RPC) protocol stream is
incorrect. Too many parameters
Hey guys,
Does anyone know a service I can use for sending sms messages from cold fusion?
I want to make an app that notifies someone by sms when their product is ready.
Kind Regards,
Rick Sanders
Canada: USA:
171 Main St
Hey Rick,
I'd say the answer depends on your situation.
A big determining factor is what carrier are the folks on that you would
be sending to? I ask because if only one carrier you can go low cost
and failry easy.
If multiple carriers, you may want to consider using an SMS aggregator
as
I worked on a system that had to do this. All I did was find out how each
system handled Email to SMS and used that.
On Tue, Nov 18, 2014 at 3:09 PM, Rick Sanders r...@webenergy.ca wrote:
Hey guys,
Does anyone know a service I can use for sending sms messages from cold
fusion? I want to
Running a page that reads a text file into an array - then writes the
array to the database.
I get the following error:*
Detail:* [Macromedia][SQLServer JDBC Driver][SQLServer]The incoming
tabular data stream (TDS) remote procedure call (RPC) protocol stream is
incorrect. Too many
http://smsgateway.riaforge.org
On Tue, Nov 18, 2014 at 6:09 PM, Rick Sanders r...@webenergy.ca wrote:
Hey guys,
Does anyone know a service I can use for sending sms messages from cold
fusion? I want to make an app that notifies someone by sms when their
product is ready.
Kind Regards,
You can either remove your CFQUERYPARAMs (which might be ok if your
data isn't coming from an untrusted source), or you can limit your
batch size so you don't exceed 2100 parameters per CFQUERY tag.
Might try this first. It's from inside a client admin system, and
there's a specifically
you need more than the gateway John ;-)
*Bryan Stevenson*B.Comm.
President CEO
Electric Edge Systems Group Inc. - makers of FACTS^(TM)
phone: 250.480.0642
cell: 250.920.8830
e-mail: br...@electricedgesystems.com mailto:br...@electricedgesystems.com
web: www.electricedgesystems.com
Thanks Bryan,
So it's like online payment. You need a gateway then a payment processor.
-Original Message-
From: Bryan Stevenson [mailto:br...@electricedgesystems.com]
Sent: Tuesday, November 18, 2014 7:32 PM
To: cf-talk
Subject: Re: Sending SMS
Hey Rick,
I'd say the answer depends
You can do this with most any sms service, they all provide an API. I use
clickatel, very simple api, can be called with a simple http post or get.
On Tue, Nov 18, 2014 at 23:50 PM, Rick Sanders r...@webenergy.ca wrote:
Thanks Bryan,
So it's like online payment. You need a gateway then a
In the grand scheme of things - yes it can be - if you need an
aggregator and can use the gateway
...and the CF gateway only works with certain APIs - depending on the
SMS aggregator - just getting an account to use that API with them can
take some doing as it has the capability to mass SPAM
Hi Russ, I don't use SOLR so this isn't an issue for my use case.
On Tue, Nov 18, 2014 at 11:57 AM, Russ Michaels r...@michaels.me.uk wrote:
did you check if SOLR still works after the upgrade ?
On Tue, Nov 18, 2014 at 3:00 PM, Michael Grant mgr...@modus.bz wrote:
I finally have an
I added SMS support using email. for example, for Verizon, it's the
phonenum...@vtext.com
I googled it and found eahc carriers domain for email-to-text and then
added a dropdown list for the carriers when my users enter their phone
number to receive texts.
I don't use any service at all, it's a
That's great but what about sending to different carriers? I'm guessing you
have to know what carrier the customer you're sending a sms is on right?
Kind Regards,
Rick Sanders
Canada: USA:
171 Main St 1205 N. Second Ave
or you could make sure your loop doesn't exceed 350 records (2100
divided by 6) by having an outer loop and an inner loop.
Could this be a job for cfthread? Split a large list up into 4 or 5
threads and just let them run (as soon as I get my head around the
math... heh)? Seems that would
That's great but what about sending to different carriers? I'm guessing
you have to know what carrier the customer you're sending a sms is on
right?
No. Its your carrier not theirs. Just like you dont need to know what
carrier someone is using to call them. Best is to use an aggregator
You can either remove your CFQUERYPARAMs (which might be ok if your data
isn't coming from an untrusted source)
This works. Tried it with a list of roughly 1000 records.
Will try my 15,000 record sheet later this evening and see what happens.
Added 4 threads to split all list up as well.
I would also change all of your passwords on the server... if it was
spyware on your local browser they now have every password you
entered recently -
~|
Order the Adobe Coldfusion Anthology now!
This may be something like that you want.
cfquery name=findDups
SELECT max(a.email_id) as email_id, a.ml_email
FROM nl_mailgroups a
inner join nl_catREL c on c.email_id = a.email_id
WHERE c.groups_id = cfqueryparam value=#req.thisGROUPID#
cfsqltype=CF_SQL_INTEGER
/
Ended up finally creating a VIEW in the database to handle the problem.
Even on a 15,000 record list, runs in just a few seconds...
| SELECT DISTINCT nl_catREL.groups_id, duplicates.ml_id
FROM nl_catREL
INNER JOIN
nl_mailgroupsON nl_mailgroups.ml_id = nl_catREL.ml_id
You need to turn use some debugging tools to help you identify the key
culprits. For example, if your query to check if a user has unsubscribed is
taking 500ms, that alone would be the reason for the slowness.
Either use the step debugger, a tool like FusionReactor or just turn on
verbose
I'm still fighting with my Excel Import application a
bit. Basically, it works pretty well, as long as
there's a limited number of records being imported.
Was testing last night with the 15,000 record Excel sheet.
If I comment out the two filter queries in the code, it will read in the
Do you have indexes on ml_email and groups_id columns? I would likely
create an index that has both in it.
There's a couple of suggestions about changing your architecture a bit:
First, from the looks of it I think you could probably combine both these
queries into one with a left join
701 - 800 of 367553 matches
Mail list logo