Are you new to programming languages?
This is Transact SQL – To The Point!
Gain the fundamentals you will need to query your databases using Transact SQL in Microsoft SQL Server.
Learn how to:
• and delete records in tables
• create databases
• create tables
• … and more.
Illustrated examples and a special section for test questions will reinforce your new knowledge of SQL.
Stop being limited by the Query Wizard in Microsoft Office Access.
Go beyond creating queries in Design View!
Over 100 SQL queries and statements along with images of results will help you learn to:
EXTRA: A special section in this guide is designed to test your skills.
Did You Know:
Learning Access’ JET SQL is a great way to become familiar and learn other forms of SQL, like Transact.
Knowledge of SQL is an important skill to display on your resume.
SQL can be learned in hours and used for decades.
Follow along with the exercises in this guide!
Download the free Northwind database from Microsoft.
The Northwind database is available in the sample templates area of Access.
Exercises and examples apply to Access 2007, 2010 and 2013.
Are You Ready To Learn SQL?
Download now and start writing SQL queries TODAY!
Scroll to the top of this page and click the 'buy button'.
More than any other application, it is always running.
You know that you can be more efficient using it.
You know there is a faster way to use its functionality.
You know you can use it better.
This eBook features tips, shortcuts and practices that will make your work day or any day run smoother.
Did You Know?
-Knowledge of SQL is an important skill to display on your resume.
-With the growth of digital information, Database Administrator is one of the fastest growing careers.
-SQL can be learned in hours and used for decades.
Learn to script Transact SQL using Microsoft SQL Server.
-Create tables and databases
-create views, stored procedures and more.
Over 100 examples of SQL queries and statements along with images of results will help you learn T SQL.
A special section included in this illustrated guide will help you test your skills and get ahead in the workplace.
Now is the time to learn SQL.
Click the 'buy button' and start scripting SQL TODAY!
Microsoft Office Excel 2013 has many new features to take advantage of like Recommended PivotTables and Timelines.
Are you new to PivotTables?
This eBook will walk you through the ins and outs.
Have you been using PivotTables for a while?
Learn tips, tricks and the latest features.
Purchase your copy today!
Don’t have Microsoft Office Excel 2013?
Many exercises are applicable to PivotTables in Excel 2010 as well.
You Need this Book
Quickly summarize large amounts of data.
Create interactive, user-friendly reports.Present concise, and attractive charts.
Do you need to know Database functions or SUMIFs?
Not at all.
All you need to know is how you want your data to look and how to click and drag with your mouse.
Learn about the new feature Slicers, and old favorites like PivotCharts.
Purchase your copy now, and create no fear, stress-free PivotTables today!
If you feel like you spend too much time in your inbox, this eBook is for you.
With 30+ Tips and Keyboard Shortcuts to Help You Organize Your Outlook.
You'll Learn How To:
Import Contacts from Microsoft Office Excel
Create Quick Steps
˃˃˃ Examples & Exercises
Use the hands-on activities in this guide as a learning tool.
Keep it close by when using Microsoft Outlook as a reference tool.
Frustrated Admin Develops Incredible Forms in Word, Makes Work Easier
Enhance the value of your documents by adding forms!
Use Microsoft Office Word To Easily Create, Distribute, and Store Forms.
Gathering information from others can be quite a task.
When you e-mail someone a form, you never know what you’re going to get in return.
If you create questionnaires, or just want information to be displayed in a specific format in Word, forms are the way to go.
You can create forms that:
˃˃˃ Examples & Exercises
Use the hands-on activities in this guide as a learning tool.
Keep it close by when using Word as a reference tool.
Exercises and examples apply to Microsoft Office Word 2007, 2010, and 2013.
Scroll up and grab a copy today.
Are you looking to enhance your skills and resume?
This is Jet SQL – to the point.
Gain the fundamentals you will need to query your databases using Jet SQL in Microsoft Office Access.
Learn how to:
SELECT data from your tables,
UPDATE data in your database,
and DELETE records in tables,
use SUBQUERIES to ask questions of your questions,
Add It All Up with SUM,
and much, much more.
Plenty of illustrated examples and a special section for test questions will reinforce your new knowledge of SQL.
Use PivotTables to Analyze Your Book Sales Fast!
You just downloaded your Smashwords Sales and Payment Report.
It is full of numbers and columns.
How can you make sense of it?
Imagine knowing in seconds which of your books sold the most copies, through what channel, and how many.
Or knowing which books weren't selling well.
That's right, it just takes seconds to create a PivotTable to analyze your sales.
I have shown numerous authors how they can open their Smashwords Sales and Payment Report and create a PivotTable in 30 seconds, and most times less.
Whether you have sold 10 books or 10,000 this book is for you.
Learn How To:
Quickly Create PivotTables
Filter Data with Slicers and Timelines
Record a Macro to Create a PivotTable for You
and much more
˃˃˃ Little to No Math Skills Needed
PivotTables do the math for you.
Create nicely formatted tables and charts that displays only the data you want to see.
˃˃˃ Examples & Exercises
Use the hands-on activities in this guide as a learning tool.
Keep it close by when using your Sales Report as a reference tool.
Examples shown can be used with Microsoft Office Excel 2007, 2010, and 2013.Scroll up and grab a copy today.
Many of my students come to my 2-day Drupal class never having authored a website before.
They always leave happily surprised at how easy, and user-friendly Drupal really is.
Now you can learn the same lessons they do, at your own pace.
This illustrated guide will answer the questions:
How do I create an Article?
How does an Article differ from a Basic Page?
I really need my site to have a Poll, Blog and Discussion Board, what about those?
Taxonomy? What’s that?
All of those questions and more are answered inside.
˃˃˃ Examples & Exercises
Use the hands-on activities in this guide as a learning tool.
Keep it close by when using Drupal as a reference tool.
Scroll up and grab a copy today.
Now Steve returns with fresh perspective to reexamine the principles that made Don’t Make Me Think a classic–with updated examples and a new chapter on mobile usability. And it’s still short, profusely illustrated…and best of all–fun to read.
If you’ve read it before, you’ll rediscover what made Don’t Make Me Think so essential to Web designers and developers around the world. If you’ve never read it, you’ll see why so many people have said it should be required reading for anyone working on Web sites.
“After reading it over a couple of hours and putting its ideas to work for the past five years, I can say it has done more to improve my abilities as a Web designer than any other book.”
–Jeffrey Zeldman, author of Designing with Web Standards
The important stuff you need to know:Dive into page design. Quickly learn the basics of working with text, images, links, and tables.Edit pages in Live view. Dynamically add elements to live pages and immediately see the results.Design once, and for all. Build fluid-grid sites that adapt themselves to desktop, tablet, and mobile devices.Troubleshoot your HTML. Use the new Element Quick View to reveal the hierarchy of page elements.Style with ease. Tap Dreamweaver’s enhanced CSS Designer to copy and paste styles.Enhance Dreamweaver. Get new program features with add-ons that integrate directly with Dreamweaver.Bring your pages to life. Use jQuery UI to add interactive page elements like tabbed content panels.Create universal pages. Avoid browser incompatibility with workarounds.
Author Josh Lockhart—creator of PHP The Right Way, a popular initiative to encourage PHP best practices—reveals these new language features in action. You’ll learn best practices for application architecture and planning, databases, security, testing, debugging, and deployment. If you have a basic understanding of PHP and want to bolster your skills, this is your book.Learn modern PHP features, such as namespaces, traits, generators, and closuresDiscover how to find, use, and create PHP componentsFollow best practices for application security, working with databases, errors and exceptions, and moreLearn tools and techniques for deploying, tuning, testing, and profiling your PHP applicationsExplore Facebook’s HVVM and Hack language implementations—and how they affect modern PHPBuild a local development environment that closely matches your production server
• Learn when to rely on themes and when it’s best to use plugins.
• Apply your responsive CSS to a WordPress theme.
• Learn various navigation techniques, such as Jump to with
• smooth scrolling or Select box.
• Use popular responsive techniques, like picturefill.js, to make images respond to different screen resolutions and connection speeds.
• Explore frameworks, including Bootstrap and Foundation.
• Download dozens of code samples to help implement responsive design techniques, and test yourself with end-of-chapter quizzes.
Many bloggers/web developers are turning to WordPress to create great websites. It has the ability for people of a non-technical background to create their own website/blog in easy steps, all the way up to advanced web developers to create stunning professional designs. There are over 100,000 new WordPress websites created every day. It is becoming a lot easier to build websites thanks to this fantastic platform.
WordPress in easy steps guides you through:Setting Up WordPressWorking with the DashboardCreating Site ContentAdding MediaAppearance and ThemesAdding PluginsCommentsSetting up Users and PrivilegesTools and SettingsWordPress Tricks
WordPress in easy steps is for:Bloggers/Hobbyist web designers, or anybody out there looking to design a website who doesn’t want to learn technical language, or bloggers looking for a great platform to work with.Web Developers: A lot of professional web design companies are using WordPress to build their websites for clients because it provides a great content management system so that the end user can add their own content once development is complete.Anybody who has had a WordPress website built for them and wants a handy reference book to help them update their own website without having to keep going back to the developer.
In this how-to companion to Don't Make Me Think: A Common Sense Approach to Web Usability, Steve Krug spells out a streamlined approach to usability testing that anyone can easily apply to their own Web site, application, or other product. (As he said in Don't Make Me Think, "It's not rocket surgery".)
Using practical advice, plenty of illustrations, and his trademark humor, Steve explains how to:
Test any design, from a sketch on a napkin to a fully-functioning Web site or application Keep your focus on finding the most important problems (because no one has the time or resources to fix them all) Fix the problems that you find, using his "The least you can do" approach By paring the process of testing and fixing products down to its essentials ("A morning a month, that's all we ask"), Rocket Surgery makes it realistic for teams to test early and often, catching problems while it's still easy to fix them. Rocket Surgery Made Easy adds demonstration videos to the proven mix of clear writing, before-and-after examples, witty illustrations, and practical advice that made Don't Make Me Think so popular.
Learn how to use the latest techniques, best practices, and current web standards—including HTML5 and CSS3. Each chapter provides exercises to help you to learn various techniques, and short quizzes to make sure you understand key concepts.
The book’s high-level overview and concrete examples will help experienced PHP web developers get started with Laravel right away. By the time you reach the last page, you should feel comfortable writing an entire application in Laravel from scratch.
Dive into several features of this framework, including:Blade, Laravel’s powerful, custom templating toolTools for gathering, validating, normalizing, and filtering user-provided dataLaravel’s Eloquent ORM for working with the application’s databasesThe Illuminate request object, and its role in the application lifecyclePHPUnit, Mockery, and PHPSpec for testing your PHP codeLaravel’s tools for writing JSON and RESTful APIsInterfaces for file system access, sessions, cookies, caches, and searchTools for implementing queues, jobs, events, and WebSocket event publishingLaravel’s specialty packages: Scout, Passport, Cashier, Echo, Elixir, Valet, and Socialite
AESTHETICS, BEAUTY, AND BEHAVIOR: Why do striking visuals grab our attention? And how do emotions affect judgment and behavior?
PLAYFUL SEDUCTION: How do you create playful engagements during the moment? Why are serendipity, arousal, rewards, and other delights critical to a good experience?
THE SUBTLE ART OF SEDUCTION: How do you put people at ease through clear and suggestive language? What are some subtle ways to influence behavior and get people to move from intent to action?
THE GAME OF SEDUCTION: How do you continue motivating people long after the first encounter? Are there lessons to be gained from learning theories or game design?
Principles from psychology are found throughout the book, along with dozens of examples showing how these techniques have been applied with great success. In addition, each section includes interviews with influential web and interaction designers.
Responsive design is not just another technique–it is the beginning of the maturation of a medium and a fundamental shift in the way we think about the web.
Implementing Responsive Design is a practical examination of how this fundamental shift affects the way we design and build our sites. Readers will learn how to:Build responsive sites using a combination of fluid layouts, media queries, and fluid media Adopt a responsive workflow from the very start of a project Enhance content for different devices Use feature-detection and server-side enhancement to provide a richer experience
Purchasing this book gives you access to the downloadable lesson files you need to work through the projects in the book, and to electronic book updates covering new features that Adobe releases for Creative Cloud customers. For access, go to www.peachpit.com/redeem and redeem the unique code provided inside this book.
Based on Cascading Style Sheets: The Definitive Guide, this reference is an easy-to-use cheatsheet of the CSS specifications you need for any task at hand. This book helps you:Quickly find and adapt the style elements you needLearn how CSS3 features complement and extend your CSS practicesDiscover new value types and new CSS selectorsImplement drop shadows, multiple backgrounds, rounded corners, and border imagesGet new information about transforms and transitions
Scalability Rules is the easy-to-use scalability primer and reference for every architect, developer, web professional, and manager. Authors Martin L. Abbott and Michael T. Fisher have helped scale more than 200 hypergrowth Internet sites through their consulting practice. Now, drawing on their unsurpassed experience, they present 50 clear, proven scalability rules—and practical guidance for applying them.
Abbott and Fisher transform scalability from a “black art” to a set of realistic, technology-agnostic best practices for supporting hypergrowth in nearly any environment, including both frontend and backend systems.
For architects, they offer powerful new insights for creating and evaluating designs. For developers, they share specific techniques for handling everything from databases to state. For managers, they provide invaluable help in goal-setting, decision-making, and interacting with technical teams. Whatever your role, you’ll find practical risk/benefit guidance for setting priorities—and getting maximum “bang for the buck.”
• Simplifying architectures and avoiding “over-engineering”
• Scaling via cloning, replication, separating functionality, and splitting data sets
• Scaling out, not up
• Getting more out of databases without compromising scalability
• Avoiding unnecessary redirects and redundant double-checking
• Using caches and content delivery networks more aggressively, without introducing unacceptable complexity
• Designing for fault tolerance, graceful failure, and easy rollback
• Striving for statelessness when you can; efficiently handling state when you must
• Effectively utilizing asynchronous communication
• Learning quickly from mistakes, and much more
In this all new edition of Communicating Design, author and information architect Dan Brown defines and describes each deliverable, then offers practical advice for creating the documents and using them in the context of teamwork and presentations, independent of methodology. Whatever processes, tools, or approaches you use, this book will help you improve the creation and presentation of your wireframes, site maps, flow charts, and other deliverables.
The book now features:
An improved structure comprising two main sections: Design Diagrams and Design Deliverables. The first focuses on the nuts and bolts of design documentation and the second explains how to pull it all together. New deliverable: design briefs, as well as updated advice on wireframes, flow charts, and concept models. More illustrations, to help designers understand the subtle variations and approaches to creating design diagrams. Reader exercises, for those lonely nights when all you really want to do is practice creating wireframes, or for use in workshops and classes. Contributions from industry leaders: Tamara Adlin, Stephen Anderson, Dana Chisnell, Nathan Curtis, Chris Fahey, James Melzer, Steve Mulder, Donna Spencer, and Russ Unger.
“As an educator, I have looked to Communicating Design both as a formal textbook and an informal guide for its design systems that ultimately make our ideas possible and the complex clear.”
—Liz Danzico, from the Foreword
Each performance rule is supported by specific examples, and code snippets are available on the book's companion web site. The rules include how to:
If you're building pages for high traffic destinations and want to optimize the experience of users visiting your site, this book is indispensable.
"If everyone would implement just 20% of Steve's guidelines, the Web would be adramatically better place. Between this book and Steve's YSlow extension, there's reallyno excuse for having a sluggish web site anymore."
-Joe Hewitt, Developer of Firebug debugger and Mozilla's DOM Inspector
"Steve Souders has done a fantastic job of distilling a massive, semi-arcane art down to a set of concise, actionable, pragmatic engineering steps that will change the world of web performance."
-Eric Lawrence, Developer of the Fiddler Web Debugger, Microsoft Corporation
Dreamweaver is the industry standard software for professionalwebsite design, with more than 90 percent of the market. In thisbook-and-DVD package, expert instructors provide a complete coursein basic Dreamweaver that you can access at your own speed.Step-by-step instructions in the book are supported by lesson filesand video tutorials on the DVD, presenting the newest version ofDreamweaver in 16 self-paced lessons. You'll learn to use stylesheets, dynamic HTML, multimedia, databases, and much more todesign, develop, and maintain your website.Newcomers to website development will learn to design andmaintain fully functioning sites using the newest version ofDreamweaver with this book-and-DVD packageThe self-paced lessons cover applying style sheets, usingdynamic HTML, adding style with images and multimedia, publishingand maintaining a website, and using databases to create dynamicwebsitesShows how to use hyperlinks to navigate throughout a website orlink to other sites on the Internet and how to format web pages andformsCreated by a team of Adobe experts who have developed trainingprograms for Adobe Systems
Dreamweaver CS6 Digital Classroom is the next best thingto having a personal tutor teach you this award-winningsoftware.
Note: DVD and other supplementary materials are notincluded as part of the e-book file, but are available for downloadafter purchase.
1. No Hosting Experience required
2.No Website building experience required
3. No Money on Domain Space to spent , Learn how
4. Learn easy way to install your Wordpress website to cloud. Harness power of cloud and make the abode of your website at cloud
5. Be online in 60 minutes
Without meaningful content, your website isn't worth much to your key audiences. But creating (and caring for) "meaningful" content is far more complicated than we're often willing to acknowledge. Content Strategy for the Web explains how to create and deliver useful, usable content for your online audiences, when and where they need it most. It also shares content best practices so you can get your next website redesign right, on time and on budget. For the first time, you'll:
See content strategy (and its business value) explained in plain language Find out why so many web projects implode in the content development phase ... and how to avoid the associated, unnecessary costs and delays Learn how to audit and analyze your content Make smarter, achievable decisions about which content to create and how Find out how to maintain consistent, accurate, compelling content over time Get solid, practical advice on staffing for content-related roles and responsibilities
• Creating robust, secure code for both the design and development levels
• Maximizing usability, reusability, accessibility, clarity, security, and performance
• Taking full advantage of the browser environments your code will run in
• Accessing the DOM to create behaviors and data interactions
• Storing data for easy and efficient access
• Using variables, functions, loops, and other core language features
• Interacting with users through events
• Communicating with servers through Ajax
C# is a complicated programming language for building.NET-connected software for Microsoft Windows, the Web, and a widerange of devices. The friendly All-in-One For Dummies formatis a perfect way to present it. Each minibook is a self-containedpackage of necessary information, making it easy to find whatyou're looking for.
Upgrades in C# 2010 include the ability to build Windows 7applications and compatibility with Python and Ruby.C# is a somewhat complex programming language for building.NET-connected software for Microsoft Windows, the Web, and otherdevicesBeginning C# programmers will appreciate how the All-in-Oneformat breaks the topic into minibooks, each one addressing a keybody of informationMinibooks include creating your first C# program, Windows 7programming, basic C# programming, object-based programming,object-oriented programming, Windows programming with C# and VisualStudio, and debuggingCompanion Web site includes all sample code
Beginning C# programmers will find C# 2010 All-in-One ForDummies explains a complicated topic in an easy, understandableway.
Note: CD-ROM/DVD and other supplementary materials arenot included as part of eBook file.
If you are a beginner who needs a solid grounding in the best practices for creating websites, this book is for you.
Written by innovative curriculum developer and university web instructor Thomas Michaud, this book provides an accessible yet comprehensive look at web design and front-end coding, covering HTML, CSS, design principles and more. You’ll learn HTML semantics, structure, and validation, and how to separate content from design using CSS (levels 1, 2, and 3). Online videos and code examples let you follow along and practice with the code.
Some of the other things you’ll learn about include:
• text elements, links, objects, and tables
• using the box model for background images, padding, borders, and margins
• fixed vs. liquid page layout
• choosing between different navigation models
• creating and styling forms
Foundations of Web Design is an indispensable resource to quickly take you from sketching to coding.
Want to build the next runaway Facebook app like Farmville orMafia Wars? Interested in leveraging Facebook app development aspart of a marketing strategy? Whether you want to build your ownFacebook app from scratch, extend an existing Facebook app, orcreate a game, this book gets you up and running in no time. Masterthe Facebook toolkit, get acquainted with the Facebook Markup andQuery languages, navigate the Facebook API—even learn how tomake money with your new app!Shows you how to build the next great Facebook application withjust basic HTML and scripting skillsDelves into what makes a good app and what makes a lucrativeappExplores how to create Facebook apps for marketing and viralreach, creating apps that can make money, and Facebook gamedevelopmentReviews the Facebook toolkit and gets you started with the MyFirst Facebook applicationCovers Facebook Markup and Query languages, navigating theFacebook API, and how to create a compelling interface
Create the next killer Facebook app with this approachable, funguide!
Use this free and easy programming language for e-commercesites and blogs
If you need to build Web and database applications quickly butyou don't dream in computer code, take heart! Ruby on Rails wascreated for you, and this book will have you up and running in notime. The Ruby scripting language and the Rails framework let youcreate full-featured Web applications fast. It's even fun!
Discover how toInstall and run Ruby and RailsUse the RadRails IDECreate a blog with RubyConnect your Web site to a databaseBuild a shopping cartExplore Ruby's syntax
Whether you’re an entrepreneur, UX/UI designer, product manager, or part of an intrapreneurial team, this book teaches simple-to-advanced strategies that you can use in your work right away. Along with business cases, historical context, and real-world examples throughout, you’ll also gain different perspectives on the subject through interviews with top strategists.Define and validate your target users through provisional personas and customer discovery techniquesConduct competitive research and analysis to explore a crowded marketplace or an opportunity to create unique valueFocus your team on the primary utility and business model of your product by running structured experiments using prototypesDevise UX funnels that increase customer engagement by mapping desired user actions to meaningful metrics
Whether you’re a Web designer, project manager, or a graphic designer wanting to learn more about the fluidity that’s required when designing for the Web, you’ll discover the tools to create the most flexible, reliable, and bulletproof Web designs. And you’ll finally be able to persuade your clients to adopt innovative and effective techniques that make everyone’s life easier while improving the end user’s experience. This book’s seven chapters deconstruct various aspects of a case-study Web site for the Tugboat Coffee Company, focusing on aspects that make it bulletproof and demonstrate progressive enrichment techniques over more traditional labor-intensive methods.
Subjects covered in this book include:
building for unanticipated future use progressively enriching designs using CSS3 properties using RGBA color for transparency with an alpha channel modular float management crafting flexible frameworks fluid layouts using grid-based design principles craftsmanship details on typography, jQuery, and shifting backgrounds
You can do this; anyone can because it's easy. Places like Webs, Yola, Wordpress, Blogger and others have made it simple with WYSIWYG editing (what you see is what you get). This book is a simple guide for everyone, from computer beginners to advanced users who will benefit from tips and over 150 useful links.
Jason Matthews is also the author of How to Make, Market and Sell Ebooks All for Free and Get On Google Front Page. He knows a myriad of online tools, programs and software to make the most of an internet career at absolutely no cost.
Plus it's fun when you save time, money and effort!
Subjects: your own website, make free website, blogging, blog, how to blog, web design, website design, internet marketing, internet business, e-business, e-commerce, wordpress, blogger, webs, yola
Souders' previous book, the bestselling High Performance Web Sites, shocked the web development world by revealing that 80% of the time it takes for a web page to load is on the client side. In Even Faster Web Sites, Souders and eight expert contributors provide best practices and pragmatic advice for improving your site's performance in three critical categories:
Speed is essential for today's rich media web sites and Web 2.0 applications. With this book, you'll learn how to shave precious seconds off your sites' load times and make them respond even faster.
This book contains six guest chapters contributed by Dion Almaer, Doug Crockford, Ben Galbraith, Tony Gentilcore, Dylan Schiemann, Stoyan Stefanov, Nicole Sullivan, and Nicholas C. Zakas.
In The Art of Scalability, Second Edition, leading scalability consultants Martin L. Abbott and Michael T. Fisher cover everything you need to know to smoothly scale products and services for any requirement. This extensively revised edition reflects new technologies, strategies, and lessons, as well as new case studies from the authors’ pioneering consulting practice, AKF Partners.
Writing for technical and nontechnical decision-makers, Abbott and Fisher cover everything that impacts scalability, including architecture, process, people, organization, and technology. Their insights and recommendations reflect more than thirty years of experience at companies ranging from eBay to Visa, and Salesforce.com to Apple.
You’ll find updated strategies for structuring organizations to maximize agility and scalability, as well as new insights into the cloud (IaaS/PaaS) transition, NoSQL, DevOps, business metrics, and more. Using this guide’s tools and advice, you can systematically clear away obstacles to scalability–and achieve unprecedented IT and business performance.
• Why scalability problems start with organizations and people, not technology, and what to do about it
• Actionable lessons from real successes and failures
• Staffing, structuring, and leading the agile, scalable organization
• Scaling processes for hyper-growth environments
• Architecting scalability: proprietary models for clarifying needs and making choices–including 15 key success principles
• Emerging technologies and challenges: data cost, datacenter planning, cloud evolution, and customer-aligned monitoring
• Measuring availability, capacity, load, and performance