Thanks Stephen, If need be, think I may have to go to a clustered web environment if the need to have more messages sent per second arrives.
Apart from having a scheduled task set to run every minute which queries the DB for the scheduled messages, can you think of any way of having a message picked up and sent at a particular time? Wasn't sure if there may be some kind of trigger command or something in SQL which would be capable of kicking off a http request with a variable in it such as the message id? Regards, Lee -----Original Message----- From: Stephen Moretti (cfmaster) [mailto:[EMAIL PROTECTED] Sent: 17 July 2004 10:26 To: [EMAIL PROTECTED] Subject: Re: [ cf-dev ] Quick question > (Newbie to the list so be gentle with me). > Welcome to the list.... We're always gentle to newbies - unless they are idiots of course. ;) > I have been looking at CFX_HTTP5 which is the same as cfhttp but > allows you to send asynchronous requests out and not have to wait for > a response to each one before sending the next. Have the system > sending up to 30 a second using this system which is not bad. > > Has anyone got ideas on how I could speed this up. I am using CFMX 6.1 > on Windows 2K and SQL Server 2000 (although I am not an SQL guru by > any stretch of the imagination). > I think you are probably going as fast as you can. The speed isn't down to how fast you're querying the database, but how fast you can make a connection to the SMS gateway via http. The query to the database, should only take fractions of a second or seconds at the most, but you're restricted by the physical limitation of networking. If you can get a direct connection to the gateway via java or some other programmatic means then you'll probably see a huge increase in the speed you can process the messages. If you're working for one of the phone companies or someone who is working closely with a phone company then there will more than like be a means to do this - you just need to find the right person to talk to. Hope that helps Regards Stephen (glad that TPS covers mobile phones too) Moretti -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED] -- These lists are syncronised with the CFDeveloper forum at http://forum.cfdeveloper.co.uk/ Archive: http://www.mail-archive.com/dev%40lists.cfdeveloper.co.uk/ CFDeveloper Sponsors and contributors:- *Hosting and support provided by CFMXhosting.co.uk* :: *ActivePDF provided by activepdf.com* *Forums provided by fusetalk.com* :: *ProWorkFlow provided by proworkflow.com* *Tutorials provided by helmguru.com* :: *Lists hosted by gradwell.com* To unsubscribe, e-mail: [EMAIL PROTECTED]
