Blog

Businessman working with tablet. Checking mark up on the check boxes. Successful completion of business tasks. Digital marketing of statistics level up of graph. Business management goal strategy.

Since the beginning of 2018,phones and other mobile devices have not only become a lot cheaper,but have also become a lot more powerful.With devices like the iPad Pro that is capable of handling desktop applications, and the Galaxy Note 9 that is an absolute powerhouse of a phone,phones are the future and nowhere is this more apparent than AMPs.Now you may be wondering what an AMP is and how it works.What is an AMP? An AMP (Accelerated Mobile Page), as the name implies,is a page on a website that is programmed to work faster on a mobile device,like a smartphone.AMPs allow your website to function much faster on mobile devices,and allow for visitors to stay longer.Although there is a massive difference between an ordinary webpage and an AMP in terms of speed,there is not much difference in terms of aesthetics.On the surface, there is no difference between an AMP and a standard web Page.This means that you are not compromising on style or aesthetics for the sake of speed or convenience.But does an AMP make that big of a difference?Yes it does,and here is how.Search Engine Priorities Other than merely convenience,AMPs affect how search engines discover and prioritize their content.Search engines, like Google and Bing, now no longer work solely on SEO and keywords; rather,they prioritize content depending on how optimized a specific webpage is.Websites that do not have well optimized webpages run the risk of not making it to the top of a search engine’s results.This is all the more concerning considering what an oversaturated market means if you are not at the top of SERPs;it means you will not get the attention of your consumers.Google is especially picky when it comes to its top search results.Google has explicitly stated in various blogs and reports that their algorithm will give a higher priority to faster and well optimized webpages compared to ones that are not optimized.Moreover, since Google is by far the biggest search engine as of now, people do even consider using any other search engine.Google has such an influence over the current generation that people even refer to searching for something on the internet as “Googling” it.Google has not made this change in its algorithm at a whim, as there is something that is clearly influencing this decision. So,is there something else that makes AMPs important? Yes, and it is the people themselves.People and TimeWith every passing generation,one thing in particular that has seen a notable decline is peoples’attention span.Patience and time is often a luxury that people in this generation cannot afford,which is why most people don’t bother with websites and webpages that are incredibly slow and irresponsive.Accordion to a report by BBC,the attention span of an average teenager is between 10 and 20 seconds.While it may not seem shockingly low,this attention span reduces even further when people are on the Internet.This means that websites have a very limited amount of time to captivate their audience, which makes the extra waiting time all the more detrimental to the overall user experience.Due to peoples’shorter attention spans,an AMP is crucial to websites that will obviously be viewed on a mobile device.How it will Affect Websites Through both a technical and an aesthetical standpoint, AMPs have absolutely no drawbacks.This means that not only are these types of webpages incredibly fast and helpful,but they don’t leave you or your viewers at a disadvantage.If websites use AMPs,they will not only rank higher in most search engines, but they will also increase the chance of converting visitors to permanent members.As a website owner, your aim should be to provide information to visitors in a fast and visually pleasing manner; it is something that you can only do effectively with the help of an AMP.Moreover,seeing how developing AMPs is not expensive, here is no reason to not add AMPs to your website.That being said, how hard is it to incorporate AMPs into a website?AMP Pages: Implementation into your Website One of the many reasons people have become vary of AMPs is because of the effort that will go into developing them.Seeing how most websites take a lot of time to create, starting from scratch to create a faster webpage may seem like a lot of effort for most websites.That being said,while you do have the opportunity to create your webpage from scratch,you can simply convert your regular HTML page to an AMP, which is more convenient. Google has released various articles and reports to better help its community of creators in converting their webpages into AMPs.Even if a third party developed your website or application,Google’s AMP has access to various types of third party applications.This makes your transition from HTML to AMP HTML all the more seamless.On the other hand,you may also be concerned about how you can add AMP pages to your WordPress website.Adding AMPs to your WordPress website is as simple as adding the AMP plugin for WordPress.This plugin will not only turn your standard HTML webpages to AMP HTML,but it will also show you how this website will look on mobile devices, which is great. You can also change the headers or the orientation of the page itself to your liking, at just a push of a button.Conclusion AMPs are possibly the most essential part of any website.It ensures that your website is functioning fast in order to keep most visitors coming back for more.Thanks to AMPs by Google, the only thing that is holding your website from reaching millions of people is your own content;so, step up your game by integrating AMP pages by Google into your websites.<table style="border-collapse: collapse; width: 100%;" border="1" data-mce-style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank,California since 2015,Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs. As a Managed Service Provider (MSP), we offer a range of services including cloud solutions, custom programming, mobile app development, marketing dashboards, and strategic IT consulting.Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business.<a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary">Contact us </a>to learn how we can assist in optimizing your IT operations.

AMP Pages

Businessman analyzing digital financial balance sheet of company working with digital virtual graphic design. Calculating long-term investment financial data icon on touch screen

The Product Requirements Got a fascinating product idea for your business? Well,having an idea is easy,but actually deploying products in a successful manner is what matters the most.Many of us can come up with an idea for a great startup or venture,but do we all think of the requirements to &nbsp;deploy it?Product requirements can involve a board strategy.This can include production planning to the development of Minimum Viable Product (MVP) by the team.As a decision maker,you need to make sure that your new product meets your current business goals and mission statement. However,below are some highlights that you need to keep in mind while deciding on your product requirements.1. Understanding the Pain Points and Business Goals People do not purchase products because they have certain features; rather,they get products to help solve problems.Consider the products you tend to use every day as well as why you use these products.For example, you probably would not state that you like LinkedIn for its direct messaging feature or newsfeed algorithm.Instead,you would say that LinkedIn helps you in finding job opportunities or hiring the best people.This is why it is important to understand pain points.Before actually launching a new product you need to understand your business goals.As an IT consultant, you need a thorough and in-depth study as to why a specific product can be a fit for your business or is in accordance with your business goals.Having extensive research regarding the product can be a good starting point. This is where you can use digital databases and cloud based products.You should also beware of creating a preliminary list of detailed requirements your product needs to meet to appeal to potential buyers.Of course,noting down a brief idea and goals for your product is a great way to start.But there is a risk that it can also lead you down the wrong path.What if your detailed Product Research Document (PRD) contains a list of all the in-depth requirements,but yet fails to answer the basic essentials of your new product.2. Research, Marketing and Gathering the Data about the Product Research and marketing play an important role to make any new product a success.Perhaps,it is one of the essential product requirements.Without analyzing the historical data and customer reviews you are not going to get things right.In the age of the internet,we have countless resources to gather relevant data.How about using online marketing tools and network to target your potential customers? Perhaps,you can also use personalized marketing. Additionally,you can also take help from focus groups to get an idea about customers will react to your product.You can use these tools to get feedback seamlessly:<ol><li style="list-style-type: none;"><ol><li style="list-style-type: none;"><ol><li>AngelList</li><li>BetaList 3. Unbounce Another great way is conducting surveys relevant to your product. Perhaps,if you lack a decent marketing budget, then reviewing websites in the same industry niche as yours and getting feedback from early adopters of your product can be helpful.You might come across a five-star rating for your competitor product. But have you gone forward and thought about all the efforts they put in to achieve that rating?</li></ol></li></ol></li></ol>With these tools, you can harness the power of email:<ol><li style="list-style-type: none;"><ol><li style="list-style-type: none;"><ol><li>Re Targeter 2. Sidekick After all,decision makers require a ton of data and metrics to reach an ultimate decision. With poor or lack of data, decision-makers might run the risk of reaching the wrong conclusion that might seriously affect the product’s feasibility.</li></ol></li></ol></li></ol>3. Convert Product Features into User StoriesA user story is a brief and self-contained piece of development work that is designed to achieve a particular goal within the product.A user story describes the desired outcome or intent of a small yet full slice of user functionality.Note that a specific product feature might comprise multiple user stories.These are some of the benefits of leveraging user stories:Stories capture desired outcomes and intent,and leave the real development instructions with the experts and specialists: the developers themselves. Stories can fit easily into sprints; in contrast, features usually can’t.As a result,stories make for more effective collaboration and scheduling. Stories are vertical; this means they represent a complete piece of functionality. Hence, they allow development teams to focus all their efforts on one complete piece of functionality 4. Make Sure To Provide Wireframes User interference (UI) is becoming a leading way to generate leads.The way you place content or “Call to Action” statements can highly impact the outcome and increase your click through rate.This has increased the demand for wireframes. In simple words, a wireframe is a tool that represents the proposed functions or elements of a new product.Wireframes are both essential for team members and clients.For team members,wireframes can give the confidence that the product is catering to users’ needs while fulfilling business objectives at the same time.Wireframes are commonly used in the early stages of the product lifecycle. Of course,you are not going to take the risk of non-visualization of your new product and leave your team hanging.For clients, wireframes help visualize the deliverable. They can also be used as a tool to get quick feedback from the client by using it as an early visual of the product. It is always easy for the client to grasp the concept in wireframes. But it is the designer that needs to put the visualization into perspective.To counter the conflict between visualization and product design, make sure you consult your designer before you forward the wireframe to your client.As a technical decision maker, you also need to make sure that your wireframe covers all the requirements of the client that can get you positive feedback.5. Prioritizing the Minimum Viable Product (MVP) How about formulating a Minimum Viable Product for the client before you actually submit the deliverable? Perhaps,this can also serve as a marketing strategy for decision makers.MVPs are becoming quite common to gather product ideas and feedbacks in the early stages.This can also be helpful in reducing the cost of a product.By actually creating the full-fledged product and customizing it later in case it is not in line with the client’s expectation.MVP is a smart way to release your outstanding product in the market or satisfactorily delivering it to the client.This can also help reduce the cost of the product by getting an early response. They are also likely to help your team gain confidence and stay motivated that they are working in the right direction.Besides, the MVP is likely to have enough basic features that will provide decent and thorough feedback to your team. As a decision maker and marketer of the product,MVP should be prioritized before you forward the deliverable to the client.<table border="1" data-mce-style="border-collapse: collapse; width: 100%;" style="width: 100%;"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank,California since 2015,Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs.As a Managed Service Provider (MSP), we offer a range of services including cloud solutions, custom programming, mobile app development, marketing dashboards, and strategic IT consulting. Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business.<a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary">Contact us</a> to learn how we can assist in optimizing your IT operations.

The Product Requirements

Male boss discussing online project with employee in the office

ADA – American with Disabilities Act and Websites With a significant rise in website accessibility lawsuits, a number of organizations are trying to endeavor their best to bring websites into compliance with WCAG (Web Consortium’s Web Content Accessibility Guidelines). This preventative measure helps them meet the criteria of web accessibility regulations, which intensified in recent years.There is no doubt that the Americans with Disability Act (ADA) is complicated legislation in terms of understanding its legal implication on web businesses. Many famous brands already faced legal implications under the ADA lawsuit as their website was not accessible to physically impaired people.Most plaintiffs are people with visual impairment and their claims are based on the fact that websites don’t have subtitles for images.Although these people can use screen readers that convert website text into audio, if there are no subtitles, they cannot figure out if that picture even exits. This is just a glimpse of issues that people have been reporting since the past few decades. Particularly, the last decade has seen an inevitable rise in mobile applications and websites, questioning the original mission of ADA to make the US society more convenient and accessible to physically impaired people.What is ADA Compliance? As mentioned earlier, ADA aims to offer protection against discriminatory behavior based on national origin, sex, race or religion.The act went a step further by mandating businesses to ensure reasonable accommodations to workers with physical impairment or disabilities.The law demands revolutionary additions to maximize the facilitation provided to physically disabled people at the workplace.Typically that&nbsp; includes wheelchair ramps,comfortable restrooms, and other accessible&nbsp; amenities to facilitate these people.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;However,with the advent of global commerce,ADA compliance became a&nbsp; confusing matter for legislators in terms of its application and compliance&nbsp; on websites.ADA Website ComplianceThere is no doubt that ADA website compliance has not only been stirring controversy for legislators but also created a lot of confusion for most people. One of the reasons is its vague description of online compliance. To put it simply, ADA doesn’t have a clear compliance policy for websites despite the fact that it has been amended several times during different web-oriented eras.Unfortunately, without any explicit policy, ADA website compliance has been challenged in the courts by many people. The purpose was to determine ADA standards that can be applied to websites.What ADA Requires for Web Accessibility? Since you know what ADA website compliance involves and where it lacks, it is better to find out what does it require to become relevant for web accessibility.Title II and Title III are the two main sections of the ADA that question its relevance for web accessibility.Title II- is an act in the ADA section that prohibits discrimination based on disability by local and state governments.Title III – is an act in the ADA section that prohibits discrimination based on disability in public places; these include private businesses that deal with the public, such as hotels, movie theaters, doctor offices, restaurants, and museums.The US justice department emphasizes that ADA doesn’t specifically address web accessibility whereas its language is comprehensive enough to incorporate websites as an integral part of your business operations. In short, the legal consensus affirms that if these sections are applicable to your business, they are also applicable to your website.ADA Web Accessibility Penalties or Lawsuitshe number of lawsuits filed in recent years against government and businesses has increased, alleging that websites have been in ADA violation. These claims mainly target websites for being inadequately accessible to physically disabled and impaired people. There were not less 814 lawsuits against different organizations from various industries, including restaurants, credit unions, banks and E-commerce websites. Both major corporations and small businesses, like Burger King, Nike, and The Hershey Company had to pay penalties for infringement.Another pertinent example is the Winn-Dixie Supermarket chain that was allegedly accused of violating ADA regulations. The famous supermarket chain did not make its website accessible to visually impaired users under ADA Title III. Despite having multiple sections, Winn-Dixie’s website was not accessible to the plaintiff who was visually impaired, preventing him from using certain services offered by Winn-Dixie grocery stores.That means no matter what type of website you have if it is not designed in a way that enables disabled people to access it without any problem, it violets ADA Title III and is at risk of facing a civil penalty from $55,000 to $75,000.Who Needs To Be Compliant?Tied to the last paragraph, it raises the question if ADA compliance for online business is mandatory for your website. Despite the fact that there is no explicit and clear description for ADA compliance for a website, it is always a good idea to stay on the safe side.Many countries have already adopted accessibility laws after seeing the rise in accessibility-related lawsuits in recent years. The success rate of plaintiffs is comparatively higher than defendants, even without clear ADA regulations.How You Can Make Your Website ADA Complaint? The best way to make your website ADA compliant is to follow WCAG 2.0 level AA guidelines. It incorporates the standard accessibility principle that many countries and the European Union have been practicing since 1999.WCAG guides you through recommended actions while keeping online accessibility laws ahead and provides a powerful business model granting equal access to everyone.By following WCAG guidelines, you can make your web content accessible to a wide range of physically impaired and disabled people including those with deafness, low vision or blindness, cognitive limitations, speech disability, limited movement, and photosensitivity.Given below is a brief review of WCAG guidelines:A website should1.Provide alternatives to visual and auditory content 2.Use style sheets and markups properly 3.Use clear and natural language 4.Create comprehensive tables with a graceful transformation 5.Feature the latest technology 6.Have direct accessibility of the user interface 7.Provide a comprehensive navigation mechanism 8.Use various interim solutions 9.Have device independence 10.Have simple and clear web pages Bottom Line Overall, there is no denying that ADA laws are still vague in terms of online accessibility. However, as an entrepreneur, it is beneficial to make sure your business practices don’t violate ADA laws and treat all customers in the same way.Sources&nbsp;1.<a href="https://www.siteimprove.com/glossary/ada-compliance/" target="_blank" rel="noopener" data-mce-href="https://www.siteimprove.com/glossary/ada-compliance/">https://www.siteimprove.com/glossary/ada-compliance/</a>2.<a href="https://www.boia.org/blog/web-accessibility-for-supermarkets" target="_blank" rel="noopener" data-mce-href="https://www.boia.org/blog/web-accessibility-for-supermarkets">https://www.boia.org/blog/web-accessibility-for-supermarkets</a>3.<a href="https://www.boia.org/blog/is-website-accessibility-required-under-the-ada" target="_blank" rel="noopener" data-mce-href="https://www.boia.org/blog/is-website-accessibility-required-under-the-ada">https://www.boia.org/blog/is-website-accessibility-required-under-the-ada</a><table style="border-collapse: collapse; width: 100%;" border="1" data-mce-style="border-collapse: collapse; width: 100%;" data-mce-selected="1"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank, California since 2015, Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs. As a Managed Service Provider (MSP), we offer a range of services including cloud solutions, custom programming, mobile app development, marketing dashboards, and strategic IT consulting. Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business. <a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary">Contact us</a> to learn how we can assist in optimizing your IT operations.

ADA – American with Disabilities Act and Websites

A concept where various creative thoughts are formed within a light bulb.3d rendering

<h3>Speeding up a Slow Website Part 2 – SQL Server</h3>Following up on the previous article – speeding up a legacy website – this posting shows how we tackled the SQL database portion of the optimization.Database Design Any developer can create a database.Most developers can create a relational database and some developers can normalize and optimize a database.However very few developers can design a database that will perform effectively over years and as transactional volume increase Initially a poor design is not apparent due to the lack of traffic and companies marvel at how quick and easy the process was.As traffic increases,the database can become a bottleneck and site slowness and other problems start to appear.Companies typically respond to this by asking developers to optimize queries or by throwing in more powerful servers,memory and updating the operating systems and database software.This however only masks the problem for the short term.ROI to Replace a Legacy System In many cases,the ROI to rebuild the database just isn’t there.A brand new database design can be costly,require a much longer deployment and outages.The database is the central piece and will usually require changes in internal and other systems and processes,requiring changes for both consumers and users.Client Challenges Recently a large e-commerce company came to us with a challenge.The client had a 16 year old website running a classic ASP website on Microsoft SQL Server that was terribly slow.They asked us to identify quick and easy ways to make it faster.Their 80 person development teams had already tried optimizing the processes and identified the database as the culprit. They even built an extensive caching mechanism that generated HTML files multiple times per week.In spite of the efforts,the e-commerce processes were still extremely slow with average page load times of 30 or more seconds.With their busiest shopping season of the year approaching they needed results quickly.The client requested a complete review with a recommendations presentation within two weeks.Vimware Approach We approached the problem by looking at the code and the database.The fundamental issue was that the developers had tried to put as little stress as possible on the database and that resulted in a less than optimal design. In this post,I will highlight the suggestions we made for the database,and will also include a link to our detailed Recommendations-SQL-Server-Database-Optimization with all company information redacted.Vimware SolutionsThe short-term solutions focused on the following:1.Incorrect indexing strategy 2.Incorrect or missing clustered indexes 3.Too many reads 4.Incorrect TempDB design 5.Irrelevant or unnecessary data being returned 6.Inefficient and poorly written SQL Server queries. 7.Incorrect SQL Server settings.In every case, there were improvements that could have been made. Medium to long-term solutions were to point out:&nbsp; &nbsp; &nbsp;<ol><li style="list-style-type: none;" data-mce-style="list-style-type: none;"><ol><li>Re-design sections of the database</li><li>Remove SQL Queries embedded in code</li><li>Modify the process of database changes</li><li>Add senior database engineer(s)</li></ol></li></ol><table style="border-collapse: collapse; width: 100%;" border="1" data-mce-style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank,California since 2015,Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs.As a Managed Service Provider (MSP), we offer a range of services including cloud solutions,custom programming,mobile app development, marketing dashboards, and strategic IT consulting.Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business.<a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary">Contact us</a> to learn how we can assist in optimizing your IT operations.

Speeding up a Slow Website Part 2 – Microsoft SQL Server

<h3>Speeding up a Slow Website – Classic ASP Code</h3>Legacy Website Complexities&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Speeding up a legacy website can be more complex than you think. Software typically has a life expectancy of three to seven years.A well designed system might last seven years while a poorly designed system will last three years,and likely much less.Many businesses have critical core business processes based on corporate software that dates back decades running COBOL,Fortran or other systems from the 1980s and earlier.ROI to Replace a Legacy System&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;In many cases,the ROI to completely overhaul the system just isn’t there. Also, the individuals who built the system might be long gone and rewriting it would be a major effort.A new system means new hardware, software licensing costs and re-training staff. Not to mention the development costs of a technology team with individuals to program, project manage, test and maintain.Because of the high costs,many companies decide to stick with their legacy system and try to make it faster by throwing more and more hardware at it.Client Challenges&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Recently a large ecommerce company came to us with a challenge.The client had a 16 year old website running classic ASP that was terribly slow. They asked us to identify quick and easy ways to make it faster.Their development teams had already implemented the basics such as optimizing images.They even built an extensive caching mechanism that generated HTML files multiple times per week.In spite of their efforts, the ecommerce processes were still extremely slow with average page load times of 30 or more seconds.With their busiest shopping season of the year approaching they needed results quickly.The client requested a complete review with a recommendations presentation within two weeks.Vimware Approach&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; We approached the problem by looking at the code and the database.The fundamental issue was that the developers had tried to put as little stress as possible on the database and that resulted in a less than optimal design. &nbsp;In this post,I will highlight the code review and high level suggestions,and will also include a link to our detailed Classic ASP recommendations with company information redacted.In the next post, I will discuss what we recommended on the database side.&nbsp; &nbsp; Vimware SolutionsThe short-term solutions focused on the following:<ol><li style="list-style-type: none;"><ol><li style="">Page/scripting issues – check that best practices were followed when developing ASP pages.</li><li style="">Embedded non-optimized SQL queries – these are calls to the database</li><li style="">Unnecessary include files – code referenced by the web page that is not needed</li><li style="">Keeping database connections open after requests</li></ol></li></ol>In every case, there were improvements that could have been made.&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Long-term solutions were to:<ol><li style="">Move embedded SQL to the database.</li><li style="">Upgrade software to .NET or other modern technology</li><li style="">Improve the database capabilities</li></ol><table style="border-collapse: collapse; width: 100%;" border="1" data-mce-style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank, California since 2015, Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs. As a Managed Service Provider (MSP), we offer a range of services including cloud solutions, custom programming, mobile app development, marketing dashboards, and strategic IT consulting. Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business.<a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary"> Contact us </a>to learn how we can assist in optimizing your IT operations.

Speeding up a Slow Website – Classic ASP Code

Internet infrastructure concept. Abstract technology background.

Vimware is a Kentico Partner after deploying multiple e-commerce sites over the last four years. To date, web sites have been built in English, French, German, Portuguese, and Spanish. Kentico helps clients create successful websites, online stores, community sites, and intranets using Kentico integrated marketing solution. With offices in the United States, United Kingdom, and Czech Republic and more than 1,000 partners in 80 countries, Kentico is one of the industry leaders worldwide and is part of Gartner’s Magic Quadrant in 2017. &nbsp;More information can be found at kentico.com and a personalized demo of the software and its capabilities can be scheduled.<table style="border-collapse: collapse; width: 100%;" border="1" data-mce-style="border-collapse: collapse; width: 100%;"><tbody><tr><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td><td style="width: 10%;" data-mce-style="width: 10%;"> </td></tr></tbody></table>Based in Burbank, California since 2015, Vimware is dedicated to supporting small to midsize businesses and agencies with their behind-the-scenes IT needs. As a Managed Service Provider (MSP), we offer a range of services including cloud solutions, custom programming, mobile app development, marketing dashboards, and strategic IT consulting. Our goal is to ensure your technology infrastructure operates smoothly and efficiently, allowing you to focus on growing your business. <a data-mce-href="https://vimware.com/about/contact-us" href="https://vimware.com/about/contact-us" data-mce-selected="inline-boundary">Contact us</a> to learn how we can assist in optimizing your IT operations.

Blog

AMP Pages

The Product Requirements

ADA – American with Disabilities Act and Websites

Speeding up a Slow Website Part 2 – Microsoft SQL Server

Speeding up a Slow Website – Classic ASP Code

Kentico Gold Partner