ASP Tips: Tip 1: Cache Frequently-Used Data on the Web Server

Performance is a feature. You need to design for performance up front, or you get to rewrite your application later on. That said, what are some good strategies for maximizing the performance of your Active Server Pages (ASP) application?

This article presents tips for optimizing ASP applications and Visual Basic® Scripting Edition (VBScript). Many traps and pitfalls are discussed. The suggestions listed in this article have been tested on http://www.microsoft.com and other sites, and work very well. This article assumes that you have a basic understanding of ASP development, including VBScript and/or JScript, ASP Applications, ASP Sessions, and the other ASP intrinsic objects (Request, Response, and Server).

Often, ASP performance depends on much more than the ASP code itself. Rather than cover all wisdom in one article, we list performance-related resources at the end. These links cover both ASP and non-ASP topics, including ActiveX® Data Objects (ADO), Component Object Model (COM), databases, and Internet Information Server (IIS) configuration. These are some of our favorite links-be sure to give them a look.

Tip 1: Cache Frequently-Used Data on the Web Server

A typical ASP page retrieves data from a back-end data store, then paints the results into Hypertext Markup Language (HTML). Regardless of the speed of your database, retrieving data from memory is a lot faster than retrieving data from a back-end data store. Reading data from a local hard disk is also usually faster than retrieving data from a database. Therefore, you can usually increase performance by caching data on the Web server, either in memory or on disk.

Caching is a classic space-for-time tradeoff. If you cache the right stuff, you can see impressive boosts in performance. For a cache to be effective, it must hold data that is reused frequently, and that data must be (moderately) expensive to recompute. A cache full of stale data is a waste of memory.

Data that does not change frequently makes good candidates for caching, because you don't have to worry about synchronizing the data with the database over time. Combo-box lists, reference tables, DHTML scraps, Extensible Markup Language (XML) strings, menu items, and site configuration variables (including data source names (DSNs), Internet Protocol (IP) addresses, and Web paths) are good candidates for caching. Note that you can cache the presentation of data rather than the data itself. If an ASP page changes infrequently and is expensive to cache (for example, your entire product catalog), consider pregenerating the HTML, rather than repainting it for every request.

A Fix() Function in T-SQL

Someone today asked me for a SQL Server function that would round a number to the first two significant places. The idea would be that 0.243 would round to 0.24, 0.00592 would round to 0.0059, and 34600 would round to 35000.

Like all good developers, I start with creating some tests. :)

I'm not using a proper testing tool here, this is just for fun - so I'm going to just make a resultset with two columns - the one that I should get, and the one that I expect to get. And I'll throw in a couple of extra numbers, to make sure I cater for the negative cases as well.

select * from
(         select 0.243 param, dbo.fix(0.243) result, 0.24 wanted
union all select 0.00592, dbo.fix(0.00592), 0.0059
union all select 34600, dbo.fix(34600), 35000
union all select -3323, dbo.fix(-3323), -3300
union all select -3.59, dbo.fix(-3.59), -3.6
) t
where t.result <> t.wanted 

Obviously this won't work yet, I don't have a function called fix (which I'm naming for the comparison with the 'fix' function in other systems). So let's create it:

create function dbo.fix(@num float) returns float as
begin
return (@num)
end

I'm using float because I'm lazy. I could use numeric, but float is quick to type, and does the job for now.

Right. Now I run my test, and all five results come back. Lovely. So now let's fix the function.

So how do we do this... well, the round() function in SQL Server will round a number nicely. It takes a parameter which is the number of decimal places you want. And it takes negative numbers. round(12345,-3) gives 12000. That's just what I'm after. So let's think about it. I want the length of the number. The length of 12345 is obviously 5 - so that works. I can convert the number into a string, count the length and get 5. Then I can get -3 from it by subtracting it from 2, which is the number of significant places I want.

Terrific. That'll work for positive integers. But the length of "1.2345" is 6, which clearly isn't right.

Here's where I feel myself turning into a real geek. I'm going to use the log10() function. log10(12345) is 4.09. Better still, log10(999) is 2.9996 and log10(1000) is 3. That's terrific. I can round that number down, add one, and there's my number length. It even works for fractions. log10(1.2345) is a little over 0, log10(0.9) is just under 0. log10(0.00343) is about -2.5. So if I round all these DOWN (that's the floor() function), and add one, I get what I need the length to be. I can't use the ceiling() function, because that wouldn't work for 1000 - for which I want a length of 4, not 3. I do actually need to round down and then add one, in case rounding down doesn't do anything.

So now I have my 'length', and if I subtract that from 2, then hopefully I get the number that I can use for the round function.

alter function dbo.fix(@num float) returns float as
begin
declare @res float
select @res = round(@num,2-(1+floor(log10(@num))))
return (@res)
end 

Well this seems to do it. Of course I could change the 2 to a 1, and stop adding one to my floor. I run my test query, and no rows are returned. Great. All done.

Except that it isn't. High-school maths reminds me that you can't take the log of a negative number. So what's going on with my tests? I check the Messages (rather than the results grid), and I see a domain error has occurred. It'd be nice if this would kick a proper error, one that would display red text and stop my query from running at all, but such is life.

Either way, we know it's a problem now, so we can fix it.

I can't take the log of a negative number, so let's check to see if the number if negative, and if it is, we can use the log of the negative number instead. I mean, I still want to round 3.6 with a value of 1, and -34334 with -3. So I'll put a case statement into my function:

alter function dbo.fix(@num float) returns float as
begin
declare @res float
select @res = case
when @num > 0 then round(@num,1-floor(log10(@num)))
else round(@num,1-floor(log10(-@num)))
end
return (@res)
end

Now my test works without an error message. "(0 row(s) affected)" is what I want to see, and there it is. I'm happy.

A minor change is to let it take another function to show many significant digits are required. Simple change:

alter function dbo.fix(@num float, @digits int) returns float as
begin
declare @res float
select @res = case
when @num > 0 then round(@num,@digits-1-floor(log10(@num)))
else round(@num,@digits-1-floor(log10(-@num)))
end
return (@res)
end

And the guy who asked me for this? Well, he's gobsmacked that there really is a use for logarithms in the real world.

Original Source: http://www.sqlservercentral.com/articles/Advanced+Querying/afixfunctionintsql/2487/

SQL - Date Convert & Sort Problem

The Problem

I'll use Northwind for an example, since it's one that most DBAs have access to on a test server. You can also reset it up from the SQL Server media if you need to. Let's look at the orders table, in particular, this query:

select top 5
 orderid
 , customerid
 , requireddate
from orders
order by requireddate desc

This is straightforward, give me the 5 orders that need to go out by the most forward "requireddate" on back. Running this gives me

orderid     customerid requireddate                                          
----------- ---------- ------------------------------------------------------
11061       GREAL      1998-06-11 00:00:00.000
11059       RICAR      1998-06-10 00:00:00.000
11074       SIMOB      1998-06-03 00:00:00.000
11075       RICSU      1998-06-03 00:00:00.000
11076       BONAP      1998-06-03 00:00:00.000

Notice that I have the June 11, 98 order first, then the June 10, the 3rd, etc. This is what I wanted, giving me the orders that will be due and working backwards. Running something like this with some flag to note if I've processed them allows me to see the newest orders coming in. I know it's a little funny, but the dates made more sense with the requireddate than the orderdate in this example.

So now suppose that your developer says that the date time thing messes him up and can you please just send back the date formatted a little nicer. Ok, no problem, so you change the query:

select top 5
 o.orderid
 , o.customerid
 , CONVERT(char(10), o.requireddate, 101) as requireddate
from orders o
order by requireddate desc

Easy enough, we add a convert to send this back as a character value instead of a datetime and then we use the 101 conversion code to specify that we want mm/dd/yyyy.
Because this is going back to a client and it's not a query we're reading in QA, we want to give the column a name that can be referenced. So we choose the same name, requireddate, to make it easier on the developer. How many of you have changed a name and had a developer scream? And if they didn't, it it because they reference values by position? Tsk, tsk, that's a no-no.

In any case, you might run this, see that it runs and send it on. But did you examine the results carefully? They look like this:

orderid     customerid requireddate
----------- ---------- ------------
10763       FOLIG      12/31/1997
10764       ERNSH      12/31/1997
10370       CHOPS      12/31/1996
10371       LAMAI      12/31/1996
10761       RATTC      12/30/1997

Notice that the first date isn't the June 11th, 1998, but rather December 31st, 1997!?!?!!!?

Whoopsi. Hopefully things weren't too date dependent.

Still, it's interesting and I bet a few people get caught by this because adding a convert doesn't. While I'm sure that there are some better explanations and more technical ones, I'll give you mine because I think it's easier to understand.

I grabbed the query plan and put it up here:

Notice the order in which things are done. First the rows are retrieved. Then the new column is computed, this being the CONVERTed date field. Lastly the sort takes place, not on the original column value as stored in the table, but rather the new computer column, as changed to a character format. In this case, the worktable in tempdb, which houses only the result data, including the computed character column, is used for the sorting. So you get 12/31 as a higher value than 06-11 and so it comes first.

So how do you avoid this?

First of all, you read lots of articles like this one where someone else has made the mistake, you chuckle at them, and then it sticks in your mind as something to watch out for. Next you rename columns when you change their values. That way when someone comes down the road and adds a new order by or group by, it doesn't affect things. That may not always work and there are definitely reasons to keep the column name the same, so then you rely on rule 1 :)

The other thing you do, and which I did not, is test carefully. Even the smallest change can affect results in ways you did not think of. That's what happened here and I thought that a simple order by would solve things. I didn't check the data carefully. I most likely used my briefcase, which has 3 articles in it, so the issue may not have even appeared for me.

As with most things, this came down to proper QA and testing. We all move too fast at times and sometimes it matters, and sometimes it doesn't. I'm sure you see similar things in your company. Mistakes and bugs will slip through. They do in all software, even in lots of other industries. What you try your best to do is learn and make fewer ones as you move forward.

--------------------------------------------------------------------------

You could read the actual article in http://www.sqlservercentral.com/columnists/sjones/anotherdbawhoops.asp

Free PHP Applications with Source Code

BLOGS
B2Evolution
Short description: A blog script featuring multiple blogs, categories/sub-categories, skins, search function, multiple languages, search engines friendly URLs.
Homepage: http://b2evolution.net/
b2evolution support forum
Disk space required: 9.98 MB

Nucleus CMS
Short description: A powerful blog script featuring multiple blogs, multiple authors, drafts and future posts, bookmarklets.
Homepage: http://nucleuscms.org/
Nucleus support forum
Disk space required: 3.5 MB

pMachinePro
Short description:This is a features limited version of pMachinePro.
Homepage: http://www.pmachine.com/
pMachine Free support forum
Purchase a license for commercial/profit use
(You need a license, in order to use pMachine Free on commercial or profit oriented websites).
Disk space required: 2.61 MB

WordPress
Short description: WordPress is a personal publishing tool with focus on aesthetics and featuring cross-blog tool, password protected posts, importing, typographical niceties, multiple authors, bookmarklets.
Homepage: http://wordpress.org/
WordPress support forum
Disk space required: 2.54 MB

CONTENT MANAGEMENT SYSTEM (CMS)

Drupal
Short description:An advanced portal with collaborative book, search engines friendly URLs, online help, roles, full content search, site watching, threaded comments, version control, blogging, news aggregator.
Homepage: http://drupal.org/
Drupal support forum
Disk space required: 1.79 MB

GeekLog
Short description: A portal system with a wide range of modules.
Homepage: http://www.geeklog.net/
Geeklog support forum
Disk space required: 16.34 MB

Joomla
Short description: Joomla! is one of the most powerful Open Source Content Management Systems on the planet. It is used all over the world for everything from simple websites to complex corporate applications. Joomla! is easy to install, simple to manage, and reliable.
Homepage: http://www.joomla.org/
Joomla support forum
Disk space required: 10.31 MB

Mambo Server
Short description: A professional level yet easy to use Content Management System featuring inline WYSIWYG content editors, newsfeeds, syndicated news, banners, mailing users, links manager, statistics, content archiving, date based content, 20 languages, modules and components.
Homepage: http://mamboserver.com/
Mambo Open Source support forum
Disk space required: 10.99 MB

PHP NUKE
Short description: One of the most popular community-based portals with a big choice of modules and languages.
Homepage: http://www.phpnuke.org/
PHP-Nuke support forum
Disk space required: 22.67 MB

PHP WCMS
Short description: phpWCMS is perfect for professional, public and private users. It is very easy to learn and gives you the flexibility to separate layout and content. Lots of powerful but simple implemented features assists publishers and web developers too.
Homepage: http://www.phpwcms.de/
phpWCMS support forum
Disk space required: 10.93 MB

PHP WEBSITE
Short description: Very powerful Content Management System with document manager, announcements, menu manager, photo album, block maker, FAQ, web pages maker, polls, information categorizer, calendar, link manager, form generator.
Homepage: http://phpwebsite.appstate.edu/
phpWebSite support forum
Disk space required: 16.54 MB

POST NUKE
Short description: A Content Management System with focus on flexibility and security. A big variety of modules and blocks makes this CMS an allround tool.
Homepage: http://www.postnuke.com/
Post-Nuke support forum
Disk space required: 17.63 MB

TYPO3
Short description: TYPO3 is a free Open Source content management system for enterprise purposes on the web and in intranets. It offers full flexibility and extendability while featuring an accomplished set of ready-made interfaces, functions and modules.
Homepage: http://www.typo3.com/
TYPO3 support forum
Disk space required: 41.21 MB

XOOPS
Short description: A very popular advanced portal system.
Homepage: http://www.xoops.org/
Xoops support forum
Disk space required: 7.09 MB

CUSTOMER RELATION MANAGEMENT (CRM)

Crafty Syntax Live
Short description: A Live Help chat system featuring monitor your visitors, proactively open a chat session, multiple chat sessions, referer
tracking, page view tracking, multiple operators, canned responses/images/URLs, multiple departments each with different icons, leave a message.
Homepage: http://www.craftysyntax.com/
Crafty Syntax Live Help support forum
Disk space required: 3.8 MB

HELP CENTER LIVE
Short description: Very powerful all-in-one help center including Live Help, Support Tickets and FAQ. Features include unlimited
operators/departments, monitor visitors, initiate chat, collect visitor's information, track visitor's footprint, autosave chat transcripts, canned
messages, leave a message, auto-assign tickets to operators, unlimited FAQ topics.
Homepage: http://www.helpcenterlive.com/
Help Center Live support forum
Disk space required: 4.64 MB

OS TICKET
Short description: A Support Tickets system featuring email piping, pop3 login, unlimited email addresses, admin/staff/user panels, avoid
autoresponder loops, limit maximun tickets user can have opened, accept attachments and limit size, pager alerts for admin.
Homepage: http://www.osticket.com/server/
osTicket support forum
Disk space required: 0.4 MB

PERL DESK
Short description: PerlDesk is a feature packed browser based help desk and email management application designed to streamline the operation of
managing emails, support tickets and customer comminications, with built in tracking and response logging it is an ideal help desk solution for companies
with one or more members of staff or for those who want to organise client communications.
Homepage: http://www.perldesk.com/
PerlDesk support forum
Disk space required: 11.73 MB

PHP SUPPORT TICKETS
Short description: A simple, one-admin Support Tickets system featuring self-registering, emailing to admin, attachments.
Homepage: http://www.phpsupporttickets.com/
PHP Support Tickets support forum
Disk space required: 0.41 MB

SUPPORT LOGIC
Short description: A Support Tickets system featuring multiple email addresses, admin/staff/user panels, canned responses, HTML tags support, email
limit on a per user/day basis, attachments.
Homepage: http://www.support-logic.com/index.php
Support Logic Helpdesk support forum
Disk space required: 3.13 MB

DISCUSSION BOARDS

PHPBB2
Short description: A widely-popular open-source bulletin-board package, works well, simple user interface and admin panel, clean look, scales
well, and can be customized.
Homepage: http://www.phpbb.com/
phpBB2 support forum
Disk space required: 2.45 MB

SMF
Short description: Elegant. Effective. Powerful. Free. SMF is all of the above. SMF is a next-generation community software package and is jam-packed
with features, while at the same time having a minimal impact on resources.
Homepage: http://www.simplemachines.org/
SMF support forum
Disk space required: 8.7 MB

ECOMMERCE

CUBECART
Short description: An easy to use yet powerful shopping cart featuring unlimited categories and products, multiple payment gateways, downloadable products. The design is very easy to modify.
Homepage: http://www.cubecart.com/
CubeCart support forum
Purchase license to remove copyright:https://www.cubecart.com/site/purchase/
Disk space required: 7.82 MB

OSCOMMERCE
Short description: A power-user shopping cart with a big variety of modules and support of almost every payment gateway. A big developers community
is ready to offer custom solutions depending on your needs.
Homepage: http://oscommerce.com/
OS Commerce support forum
Disk space required: 5.34 MB

ZENCART
Short description: Zen Cart truly is the art of e-commerce; a free, user-friendly, open source shopping cart system. The software is being developed
by group of like-minded shop owners, programmers, designers, and consultants that think e-commerce could be and should be done differently.
Homepage: http://www.zen-cart.com/
Zen Cart support forum
Disk space required: 12.17 MB

FAQ SOFTWARES

FAQ MASTER FLEX
Short description: Unlimited categories/questions/answers, web-based administration.
Homepage: http://www.technetguru.net/design/faqmasterflex.php
Disk space required: 0.09 MB

GUEST BOOKS

FAQ MASTER FLEX
Short description: The ViPER Guestbook is a high end guestbook script that is versatile, reliable, very comfortable and easy to use. The perfect
choice for the ambitious webmaster !
Homepage: http://www.vipergb.de.vu/
ViPER Guestbook support forum
Disk space required: 3.82 MB

HOSTING BILLING

ACCOUNT LAB PLUS
Short description: AccountLab can lookup over 180 TLD's, have unlimited hosting plans, offer monthly, quarterly, six monthly and yearly
payment options, handle tax. AccountLab works with PayPal, WorldPay (FuturePay), NoChex, 2checkout and offline payments such as checks or bank transfer.
Homepage: http://www.netenberg.com/accountlabplus.php
AccountLab Plus support forum
AccountLab Plus Notice:
AccountLab Plus requires a license. Purchase an AccountLab Plus licensehere.
Disk space required: 2.94 MB

PHP COIN
Short description: A full billing/invoicing application, perfect for webhosting resellers.
Homepage: http://www.phpcoin.com/
phpCOIN support forum
Disk space required: 5.92 MB

IMAGE GALLERIES

4 IMAGES GALLERY
Short description: An Image Gallery system featuring unlimited categories/subcategories, web-based and FTP images upload, auto-thumbnails,
comments, send a picture, rate a picture, random pictures, extensive administration panel.
Homepage: http://www.4homepages.de/
4Images Gallery support forum
Purchase a license for commercial/profit use
(You need a license, in order to use 4Images Gallery on commercial or profit oriented websites).
Disk space required: 1.67 MB

COPPERMINE PHOTO GALLERY
Short description: An Image Gallery system featuring categories and albums, thumbnails and intermediate size pics, search feature, new and random
pictures, user management (private galleries, groups), user comments, e-cards feature, slideshow viewer.
Homepage: http://coppermine.sourceforge.net/
Coppermine Photo Gallery support forum
Disk space required: 10.29 MB

PHOTO GALLERY
Short description: An Image Gallery system featuring albums within albums, thumbnailing specific picture area, captions, rotate, reorder pictures,
album-based attributes, album mirroring.
Homepage: http://gallery.menalto.com/
Gallery support forum
Disk space required: 26.33 MB

MAILING LIST

PHP LIST
Short description: A powerful mailing list featuring multiple mailing lists and attachments.
Homepage: http://www.tincan.co.uk/
PHPlist support forum
Disk space required: 6.75 MB

POLL AND SURVEYS

ADVANCED POLL
Short description: A highly windows-inspired poll script.
Homepage: http://www.proxy2.de/scripts.php
Advanced Poll support forum
Disk space required: 1.25 MB

PHP ESP
Short description: PhpESP is an effective, capable, web-based survey application that enables businesses to create complex and advanced surveys, view
results in real time, and carry out advanced analysis.
Homepage: http://phpesp.sourceforge.net/
phpESP support forum
Disk space required: 3.99 MB

PHP SURVEYOR
Short description: Develop, publish and collect responses to surveys. Display surveys as single questions, group by group or all in one page or use a dataentry system for administration of paper-based versions of the survey. PHP Surveyor can produce 'branching' surveys (set conditions on whether individual questions will display), can vary the look and feel of your survey through a templating system, and can provide basic statistical analysis of your survey results.
Homepage: http://www.phpsurveyor.org/
PHPSurveyor support forum
Disk space required: 6.1 MB

PROJECT MANAGEMENT

DOT PROJECT
Short description: Project Management featuring companies, projects, tasks (with Gantt charts), forums, files, calendar, contacts, tickets/helpdesk, language support, user/module permissions, themes.
Homepage: http://www.dotproject.net/
dotProject support forum
Disk space required: 8.77 MB

PHP PROJEKT
Short description: Project Management featuring optional group system, privileges, calendar, contacts, time card, projects, chat, forum, request tracker, mail client, files, notes, bookmarks, to-do list, reminder, voting, language support.
Homepage: http://www.phprojekt.com/
PHProjekt support forum
Disk space required: 7.82 MB

SOHOLAUNCH PRO EDITION
Short description: From basic, informational websites to robust e-business applications, this script vastly simplifies the creation and management of cutting-edge internet solutions. It installs at the end-users web site and empowers novices and seasoned developers alike with a streamlined development and management process unmatched by any other software product.
Homepage: http://www.soholaunch.com/
Soholaunch Pro Edition support forum
Disk space required: 24.58 MB

WIKI

TIKI WIKI
Short description: TikiWiki is designed to be an international, clean and extensible Content Management System and Groupware that can be used to create all sorts of web applications, sites, portals, intranets and extranets. TikiWiki also works great as a web-based collaboration tool. TikiWiki has a lot of native options and sections that you can enable/disable as you need them.
Homepage: http://www.tikiwiki.org/
TikiWiki support forum
Disk space required: 41.73 MB

PHP WIKI
Short description: PhpWiki is a web site where anyone can edit the pages through an HTML form. Linking is done automatically on the server side; all pages are stored in a database.
Homepage: http://phpwiki.sourceforge.net/
PhpWiki support forum
Disk space required: 1.35 MB

OTHER SCRIPTS

DEW-NEW PHP LINKS
Short description: A Link Directory featuring categories, reviews, popular links, new links, links approval.
Homepage: http://www.dew-code.com/
Dew-NewPHPLinks support forum
Disk space required: 1.35 MB

MOODLE
Short description: A course management system designed to help educators create quality online courses. Available in 34 languages and features a WYSIWYG HTML editor. The teacher has full control over all settings for a course. There is a flexible array of course activities (Forums, Journals, Quizzes, Resources, Choices, Surveys, Assignments, Chats, Workshops), user logging and tracking, mail integration and much more.
Homepage: http://moodle.org/
Moodle support forum
Disk space required: 83.39 MB

NOAH'S CLASSIFIEDS
Short description: A classifieds system featuring categories and subcategories in unlimited depth, image upload for categories and classifieds, variable fields per categories, customizable email notifications, locking categories, classifieds approval, auto-thumbnail generation, classifieds management by user, send classified to a friend.
Homepage: http://classifieds.phpoutsourcing.com/
Noahs Classifieds support forum
Disk space required: 1.66 MB

OPEN REALTY
Short description: Real Estate listing system featuring attachments, flexible search, template system, Yahoo Maps interface.
Homepage: http://www.open-realty.org/
Open-Realty support forum
Disk space required: 3.54 MB

PHP ADS NEW
Short description: A highly professional complete ad server featuring different types of ads, display based on keywords, zones, hour of the day, day
of the week, extensive statistics, client statistics.
Homepage: http://phpadsnew.com/
phpAdsNew support forum
Disk space required: 8.09 MB

PHP AUCTION
Short description: The GPL version of PHPauction featuring email notification of bids, attachments, reserve price, minimum bids, standard and dutch auctions, bid history, send auction to a friend, highest bids, auctions ending soon.
Homepage: http://www.phpauction.org/
PHPauction support forum
Disk space required: 3.82 MB

PHP FORM GENERATOR
Short description: A form generator featuring up to 100 form fields, all kind of input fields incl. file upload, customizable fields attributes, send
submitted data to an email address or store them in a database, admin panel.
Homepage: http://phpformgen.sourceforge.net/
phpFormGenerator support forum
Disk space required: 0.5 MB

WEB CALENDAR
Short description: A very powerful webcalendar featuring private and public calendars.
Homepage: http://webcalendar.sourceforge.net/
WebCalendar support forum
Disk space required: 3.41 MB

Access Your PC from Anywhere

Check Email. Transfer Files. Use Your Applications. Access Your Network. From Anywhere. GoToMyPC is the fast, easy and secure way to access and control your computer from any Web browser, anywhere. TELEWORK: Access your office PC from home, easily and securely, with just an Internet connection. TRAVEL: Access and use your computer from hotels, airports, satellite offices, Internet cafes – anywhere with Web access. LAST-MINUTE ACCESS: Get that file or email you left at the office from anywhere, anytime. See why GoToMyPC is revolutionizing the way people work remotely: Register and download it now. Complete Satisfaction Guaranteed: Pay nothing for this risk-free, full-functioning trial. How It Works.