Making my coldfusion app available on an intranet???

I have a coldfusion mx app working now. How do i make it available on an intranet?? In other words, what do I have to do to let other people use it.

 How do i make the URL that they type in, right now it is http://localhost:8500/TT/salestool.cfm


Also another question,

anyone know the max size of a database that can be used with coldfusion mx?
finnstoneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TallerMikeCommented:
Well, you could try having them access it either through your IP address or your computer name on the network like so:

http://192.168.0.1:8500/TT/salestool.cfm

http://finnStonesComputer:8500/TT/salestool.cfm

I don't think there is such thing as a maximum DB size for Cold Fusion. Your servers may have a limit based on their harddrive, processor, and memory, but I don't think Cold Fusion has a limit.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
finnstoneAuthor Commented:
is there any way to totally change the URL so that it reads like

 http://tool.cfm ?

0
TallerMikeCommented:
No. You have to go somewhere to get to the application. You at LEAST would need the following:

http://computerName/tool.cfm

But there is no way for you to do the following:

http://tool.cfm
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

substandCommented:
alternatively, you could edit the hosts file on everyone's computer to contain the line:

127.whatever.your.ip.is  <this is supposed to be a tab> doubleclick.net


then you get an easy to remember domain name for your application and the added benefit of a reduction in advertising.
0
TallerMikeCommented:
True, you could do that as long as your edited EVERYONES host file. So basically you're giving them an alias to your IP address or computerName. It's a good point, but you still can't do this:

http://tool.cfm
0
finnstoneAuthor Commented:
wow that was a dumb question i should have just tried that...thank you very much...at what point does performance get bad when talking about size of the database?
0
substandCommented:
as long as you set your db up right, it shouldn't ever perform bad..

of course, that depends on what the DB is.  for example, SQL Server will perform much better than MS Access.
0
TallerMikeCommented:
You should be fine up into the Gigabytes as long as you properly index your tables and are VERY careful about creating optimized queries. You'll want to take all of your queries (one at a time) and put them into Query Analyser and do an Index Analysis to determine if you have set them up correctly (you can't do this until you have a fair amount of data in the DB so that it knows what fields need indexing and what the costs of doing so will be).

If you have any code that queries a recordset, then loops through it running another query for each row returned, then you've got some work to do. You'll need to remedy all of those with mroe complex queries.

If you're not using CFQUERYPARAM on all of your queries, you'll need to change that too. It allows the DB to remember that a similar query was run.

If you're using Access... then you'll need to start using SQL Server or Oracle. Access will NOT cut it for a large DB.

You'll want to start getting familiar with stored procedures.

And with a large database usually comes a large quantity of data. SO make sure that your queries ONLY return the data that is needed (no extra rows, no extra columns). Do a search on "SELECT *" and get rid of every instance, replace it with a list of neccesary columns.

So in short, how much you can handle is determined by the specs of the server, and how well you wrote your code. A few pieces of innefficient code can bring a GigaByte DB server to it's knees very quickly.
0
TallerMikeCommented:
Be sure to read the following post on other Optimization Techniques:

http://www.experts-exchange.com/Web/WebDevSoftware/ColdFusion/Q_20542979.html
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Servers

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.