Blog

Adding Hints to Dynamically Generated App Engine SQL

: Created on Saturday, 21 August 2010 17:59; Written by Chris Heller

Dave Kurtz has a nice writeup over at OakTable.net on using App Engine meta-sql to add hints to dynamically generated SQL.

I missed it when it was first published back in March, but it just came in handy for me. Thanks Dave!

Labels: 2010, AppEngine, Performance, sql

Add your comment

yvComment v.2.00.2

News Archives

► 2012
- ► April
  - • 23 - TCU Goes Live with PeopleMobile
- ► March
  - • 29 - You are now free to move about the enterprise
  - • 14 - Alliance 2012: Pre-conference Training Sessions
  - • 13 - Gartner’s Top Predictions for IT Organizations and Users, 2011
- ► February
  - • 29 - IDC Smartphone Adoption Survey
  - • 28 - HEUG Alliance 2012 - Customer Mobile presentations
  - • 13 - PeopleSoft Mobile on BlackBerry
- ► January
  - • 30 - What's New in PeopleTools 8.52 - Video Available
  - • 23 - Getting Started in PeopleSoft Mobile YouTube Video
  - • 12 - JQuery Mobile test lab
  - • 11 - UK and EU customer visits
  - • 09 - Drilling URLs and Pagelet WIzard
► 2011
- ► December
  - • 29 - Mobile Implementation Considerations for PeopleSoft
- ► September
  - • 16 - HEUG forum post from TCU about our Mobile solution
  - • 08 - BI Publisher versus PeopleSoft XML Publisher
  - • 08 - Best Practices in XML Publisher Reporting
  - • 05 - Advanced nVision tips and techniques
  - • 05 - Best Practices in implementing PeopleSoft Self Service
  - • 05 - The Lane County Single Signon Story
  - • 05 - Taming Change - The University of Western Ontario's change management journey
  - • 04 - Amazon.com redesigns its website around mobile
- ► July
  - • 09 - Featured Vendor - Illinois Technology Association
  - • 24 - Kerberos tickets at login time on Mac OS X
  - • 29 - Mobile for PeopleSoft
- ► June
- ► May
  - • 26 - Chicago Office Opens
  - • 26 - HIUG Interact conference 2011
- ► March
  - • 04 - Navigation Changes in PeopleTools 8.51
  - • 10 - Powerpoint from Development Best Practices Webinar
  - • 21 - PS/nVision is not configured properly on this workstation
  - • 23 - HEUG Alliance 2011
  - • 23 - PeopleSoft Test Framework Tables
- ► February
  - • 01 - QVC Chooses Grey Sparling for Version Control
  - • 02 - Grey Sparling is Hiring - Solutions Architect
  - • 23 - Oracle Customer Advisory Board meeting
► 2010
- ► October
  - • 01 - PeopleSoft Testing Framework - Supply Chain (Inventory, Purchasing, Procurement, and Payables)
  - • 13 - Introducing Automatic URL Shortening for your PeopleSoft URLs (automatic bit.ly or TinyURL for PeopleSoft)
- ► September
  - • 03 - Tuxedo Listening on Multiple IP addresses
  - • 10 - PeopleTools 8.51 Initial Impressions
  - • 14 - Your security options are set improperly. Please contact your security administrator.
  - • 20 - Advanced PeopleSoft Security Audit - OpenWorld 2010
  - • 20 - PeopleSoft Enterprise Release 9.1 Adoption and Roadmap
- ► August
  - • 21 - Adding Hints to Dynamically Generated App Engine SQL
  - • 23 - PeopleSoft Component Interface Testing Tools
- ► July
  - • 09 - Syntax Highlighting for PeopleSoft SQL Traces
- ► June
- ► April
  - • 06 - The PeopleSoft/IBM backstory
- ► March
  - • 10 - Please don't mirror the site every 5 seconds
- ► February
  - • 21 - Java PeopleSoft
- ► January
  - • 01 - Diff/Merge Page in PeopleSoft Application Designer
► 2009
- ► December
  - • 10 - Related Content Feature in PeopleTools 8.5
- ► November
  - • 08 - Application Designer on Linux
- ► October
  - • 12 - OpenWorld 09 - PeopleSoft Upgrades - A Customer's Perspective
  - • 12 - OpenWorld 09 - PeopleSoft 9.1 Overview / Keynote
  - • 13 - OpenWorld 09 - Oracle Enterprise Manager with PeopleSoft
  - • 13 - OpenWorld 09 PeopleSoft 9.1 Financials Overview
  - • 13 - OpenWorld 09 PeopleTools 8.5 Customer Perspective
  - • 25 - In Depth - PeopleTools 8.50 RSS Feed Publishing Framework
- ► September
  - • 21 - PeopleTools 8.50 RSS Feed Publishing Framework
- ► August
  - • 04 - PeopleTools on Vista
  - • 05 - Sun Continuous Integration Server (aka Hudson
  - • 10 - Oracle JDeveloper 11gR1 with PeopleSoft
  - • 11 - Oracle JDeveloper 11gR1 with PeopleSoft - part 2
  - • 24 - Protecting PeopleSoft against "Real-Time" Secure ID Snatching
  - • 27 - Figuring out where your Financial Data came from
- ► July
  - • 08 - Using PeopleSoft Performance Monitor
  - • 24 - Increasing System Availability with PeopleSoft
- ► June
  - • 28 - Security Issues With PeopleSoft Production Refreshes
  - • 22 - Automating Forced Windows Logout for Kiosks
- ► May
  - • 02 - PeopleSoft Test Automation
  - • 10 - Functional Testing of PeopleSoft Applications
  - • 19 - PeopleCode Unicode Variable Names
  - • 29 - Multiple field nPlosion for Peoplesoft nVision
- ► April
  - • 02 - Testing PeopleSoft LDAP integration with Active Directory
  - • 02 - New Webinars Posted
  - • 02 - Getting more from MetaLink (soon to be "My Oracle Support")
  - • 15 - PeopleTools Patches
  - • 25 - IBM's Oracle emulation
  - • 26 - Issues with Dynamic Roles in PeopleSoft
  - • 29 - Oracle VM Templates for PeopleSoft Now Available
- ► March
  - • 03 - PeopleCode Editor Shortcuts
  - • 10 - Emailing Scheduled PS/Query Results
  - • 10 - Version Control for PeopleSoft demo
  - • 17 - Una historia de PeopleTools
  - • 21 - ActiveDirectory and PeopleCode integration
  - • 25 - Introducing Code.GreySparling.com
- ► February
  - • 03 - Remote access to PSADMIN
  - • 04 - One time passwords
  - • 05 - Keystroke loggers
  - • 07 - Fixing PeopleSoft Workflow Email Notifications
  - • 07 - Charles Phillips named to economic recovery board
  - • 15 - Out of Available Memory error running Application Engine
  - • 20 - Grey Sparling "PeopleSoft Experts" Webinar Series
  - • 23 - New Webinar: Social Networking with your PeopleSoft Application
  - • 23 - New Webinar: Advanced Troubleshooting for your PeopleSoft Environment
  - • 23 - New Webinar: Meet the Experts Virtual Open Roundtable
  - • 23 - New Webinar: What you should know about the PeopleSoft Ecosystem
- ► January
  - • 22 - Which PeopleSoft system am I working in?
  - • 26 - Taking control of your build files
► 2008
- ► November
  - • 14 - Overlapping Text in PeopleSoft and Safari 3.x
- ► September
  - • 04 - Initial Testing with PeopleSoft using the Chrome browser
  - • 06 - One in a million
  - • 11 - Workday slowly following the PeopleSoft path
  - • 15 - Helping our friends in the Financial Services Industry
  - • 22 - LDAP Query Syntax Tips
  - • 28 - OpenWorld Wrap-up
- ► August
  - • 01 - Getting better Control of your reports.
  - • 09 - Oracle Virtual Machine Templates
  - • 19 - Correction on 2007 Open World session writeup
- ► July
  - • 06 - PeopleSoft IVR Integration the easy way
  - • 07 - PeopleSoft telephony two factor authentication
  - • 08 - nVision using Queries intricacies
  - • 11 - Tightening Data Security in your PeopleSoft Environment
  - • 21 - OpenWorld sessions from Oracle Mix voting winners announced
- ► May
  - • 20 - 2008 PHRUG Wrap-Up
- ► April
  - • 09 - Reporting against multiple Setids in PeopleSoft
  - • 11 - Firewall Product as Savior
  - • 13 - Collaborate 2008
  - • 15 - International Rollouts of PeopleSoft - Do's and Don'ts
  - • 15 - Strengthening Data Privacy in PeopleSoft
  - • 23 - Enterprise RSS Day
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 1 - A43910: Business Intelligence – A look at Oracle's Business Intelligence tool out of the box
  - • 25 - Collaborate Day 2 - E40790- PeopleSoft Executive Update with Doris Wong
- ► March
  - • 28 - Setting Report Retention Limits dynamically for Report Manager
  - • 07 - Grey Sparling 2008 Spring Events
  - • 14 - Can you use Winter or Node-Oriented Trees in GL?
  - • 13 - Baby steps with Reporting against PeopleSoft
  - • 12 - Code Escrow 2.0
  - • 17 - Links not Automatically Opening a Page
  - • 20 - Creating a Shortcut to Opening a Query in Windows Query
  - • 26 - Client/Server Single Signon for PeopleSoft
- ► February
  - • 14 - Using Instant Messaging to Enrich PeopleSoft
  - • 19 - Ramifications of Annoying your co-workers in a call center...
  - • 29 - Using Flash for End-User Training
- ► January
  - • 09 - Silly Blog Games
  - • 09 - Upgrading to Fusion
  - • 24 - Helpdesk support in the middle ages
► 2007
- ► December
  - • 05 - "More Advanced Reporting Tips and Techniques for PeopleSofft Enterprise" powerpoint
- ► November
- ► October
  - • 08 - What does SAP's Acquisition of Business Objects Mean?
  - • 10 - Opening up a Performance or Development Document from a URL
  - • 11 - Re-Posted yesterday's item.
  - • 12 - BEA acquisition impact for PeopleSoft customers?
  - • 23 - Looks like someone didn't implement workflow for approving vendor payment changes.
  - • 25 - A Better Way to Manage PeopleSoft Windows Services
- ► September
  - • 21 - Creating Optional Parameters for a PeopleSoft page
  - • 21 - Drilling Deeper into PeopleSoft Pages
  - • 24 - Code to Drill to any Chartfield Combination on Journal Entry Page
  - • 25 - Insatiable Application Classes
  - • 26 - Security Zone Management in Internet Explorer
- ► July
  - • 09 - Grey Sparling Excel Add-in for PeopleSoft
  - • 19 - The Good, Bad, and Ugly of our Niche...Part 1
  - • 23 - The Good, Bad, and Ugly of our Niche... Part 2
  - • 26 - The Good, Bad, and Ugly of our Niche... Part 3
- ► June
  - • 04 - Upcoming Events
- ► May
  - • 13 - History of Tree Manager
  - • 14 - Advanced VBA Hooks in nVision
  - • 15 - Post-processing Query output in Excel
  - • 24 - A Brief History of PeopleTools 9
- ► March
  - • 16 - Query and nVision Reporting in Student Admin
  - • 16 - Financials Objects for Drilling Demos
  - • 16 - Alliance Conference 2007 Wrap-Up
  - • 20 - Alliance 2007 Session Evaluations
- ► January
  - • 02 - Grey Sparling 2006 In Review
  - • 09 - Query and nVision Reporting in HCM
  - • 10 - Flash Demo of HCM ReportingFlash Demo of HCM Reporting
  - • 12 - January through March Grey Sparling Events
► 2006
- ► November
  - • 23 - Advanced Run Control Techniques for Process Scheduler
- ► October
  - • 27 - Oracle Open World 2006 Wrap-Up
  - • 18 - Query Drilling URL Feature in PeopleTools 8.5 Review
- ► September
  - • 11 - Financial Transparency Tool
  - • 15 - Report Manager Performance
  - • 19 - Little known work-around for many nVision bugs...
  - • 21 - Desktop Single Signon for PeopleSoft
  - • 29 - Open World Update - Session Popularity
- ► August
  - • 03 - Managing Processing Time Limits
  - • 04 - Presenting at Oracle OpenWorld 2006
  - • 08 - Drag and Drop stopped working in Tree Manager?!?!
  - • 13 - Associating database connections with PeopleSoft users
  - • 14 - IE August Update Crashes PeopleSoft
  - • 21 - PS/nVision and Other Reporting Techniques Presentation
  - • 23 - Application Designer Index Management tip
  - • 25 - Hiding the PeopleSoft Pagebar in all component
  - • 30 - Determing the PeopleSoft Portlet URL
  - • 30 - Passing additional parameters to PeopleSoft pages
  - • 30 - Java and PeopleCode Tips and Tricks - Part 3
- ► July
  - • 12 - New Tool for PeopleSoft Application Developer Productivity
  - • 27 - Grey Sparling Experts coming to a city near you!!!
- ► June
  - • 09 - Oracle 12 Applications User Interface
  - • 18 - Fixing PeopleSoft Copy-URL for Firefox
  - • 20 - PeopleCode and C Integration
  - • 23 - Oracle-PeopleSoft Bloggers
- ► May
  - • 04 - App Designer 3 tier login from the command line
  - • 08 - Deeper dive explanation of Siebel Analytics by Mark Rittman
  - • 13 - Application Engine Development Tips
  - • 18 - nVision with Query Prompts
  - • 18 - Little known Row Level Security hook
  - • 22 - Fixing Report Manager
- ► April
  - • 05 - Enhancing the PeopleSoft for Administrators
  - • 20 - nVision Drilling Performance and Latency
  - • 27 - PeopleSoft Single Signon
  - • 29 - nVision and Siebel Analytics
- ► March
  - • 03 - nVision Power Drilling (Pages, Queries, Drilldown Layouts, and more)
  - • 16 - nVision and Fusion
  - • 23 - Darth Ellison vs Jedi ABAP
  - • 23 - Java and PeopleCode Tips and Tricks - Part 2
- ► February
- ► January
  - • 06 - Using PS/nVision to print your trees.
  - • 06 - Using Styles and nVision
  - • 09 - Follow-on to styles and nVision
  - • 18 - Integrating GoogleTalk with PeopleSoft
  - • 19 - Dynamic PeopleSoft Security Based on Login
  - • 23 - PeopleSoft Version Control
► 2005
- ► December
  - • 27 - How Chartfields are identified in GL
  - • 27 - Materialized Views and Row Level Security
- ► November
  - • 01 - October Update
  - • 11 - Filtering nVision for date and quarter
- ► October
  - • 14 - Understanding Row Level Security
  - • 16 - Why You Should Avoid PeopleCode For Row Level Security
- ► September
  - • 16 - Handling Rogue Queries in PS/Query
  - • 20 - Using Cube Manager to solve data merging issues
  - • 29 - Drilling to other content in nVision
  - • 29 - Hierarchical Reporting in nVision
- ► August
  - • 01 - nVision hanging problem
  - • 02 - Field Level Security in PS/Query
  - • 03 - Magic with Content Cells
  - • 04 - Accessing data from two different database instances
  - • 08 - PeopleSoft Trivia - the source control rule...
  - • 12 - Inside PeopleSoft trees - or - Photosynthesis at PeopleSoft
  - • 19 - Report Distribution with 3rd party solutions...
  - • 22 - Organizing reports in Report Manager prior to Tools 8.4
  - • 23 - Meet the Experts
  - • 26 - Improving the drilling usability in nVision
  - • 31 - Understanding Setids and Business Units
- ► July
  - • 20 - Doing Ledger-based nVision reporting in EPM
  - • 21 - To Customize or not to Customize, that is the question...
  - • 22 - Tricking PeopleSoft to do what you want - Part 1
  - • 23 - NorCalPRUG Meeting Notes -- Morning
  - • 25 - NorCalPRUG Meeting Notes -- PS/nVision vs. e.Spreadsheet
  - • 25 - Strategic Structure Alignment, Part 1
  - • 25 - NorCalPRUG Meeting Notes -- Technical Roundtable Notes
  - • 25 - Knowledge Networks versus Organization Structures
  - • 26 - nVision performance tuning
  - • 28 - Embedding Macros into nVision reports
  - • 29 - Training PS/Query to do new tricks...

Blog

Adding Hints to Dynamically Generated App Engine SQL

Add your comment

News Archives

Recent Comments

Tags

Your name:
Comment: