 | Particularly in a means of moving PowerBuilder app... |
MOST READ THIS WEEK By Virtualization News Desk | | By Oscar Uriel Tobar Rios | | | By PowerBuilder News Desk |
YOUR FEEDBACK Gregor Rosenauer wrote: well, not what's your take on this? Did I miss a second page of this article or... Oct. 6, 2008 02:45 PM |
|
All Things New
SQL or Stored Procedures
When we last left off, we had a functional shell of an application. We had a menu that would open our five different sheets (Controls, Users, Messages, Menus, and Contacts); we had the shell of those five sheets themselves; we had some basic shared functionality with regards to managing sheets (arranging sheets, closing all open sheets); we had some basic shared DataWindow/DataStore error handling in the DBError event of our base-class u_dw and n_ds objects; we had some basic transaction management hooks in place in our base-class n_tr transaction object.
Reader Feedback: Page 1 of 1
#2 |
Sandy Turner commented on 12 Jul 2006
This article states the following:
"Depending on the nature of your data, however, it's very important to have the stored procedure recompiled periodically to ensure that the saved query plan is optimal for the data in the table. You can usually have the DBA group recompile your procedures weekly or at whatever interval is required."
Based on the DBMS, the recompilation of your stored procedures periodically is not necessary. ORACLE, for instance, determines the execution plan each and every time the procedure is executed. SQL*Server, on the other hand, does not.
|
#1 |
SYS-CON India News Desk commented on 15 May 2006
When we last left off, we had a functional shell of an application. We had a menu that would open our five different sheets (Controls, Users, Messages, Menus, and Contacts); we had the shell of those five sheets themselves; we had some basic shared functionality with regards to managing sheets (arranging sheets, closing all open sheets); we had some basic shared DataWindow/DataStore error handling in the DBError event of our base-class u_dw and n_ds objects; we had some basic transaction management hooks in place in our base-class n_tr transaction object.
|
YOUR FEEDBACK  | By Ryan A. Mercer David Hauze wrote: Table 1 and other links within the text referring to other items not available in the article are not working. Specifically, the one I need is the Table 1 link. | | By Bruce Armstrong Leo wrote: Can you tell me how can I deploy it to the client' pc? | | By Bruce Armstrong Keith Keller wrote: good luck, Sybase. I left PB development 14 months ago and have not looked back. I hope PB 12 does well. i've been doing asp.net and ajax development ever since along with the datawindow.net component and it's been GREAT! | | By Bruce Armstrong Leo wrote: I have tried to pulibc a UserControl via Interop Forms Toolkit 2.0. It work when i used it in VB6. However, only event can be seen when i used it PB9 | | By Dan Weisberg Java Web Development wrote: Excellent Article on Developing.......
Java Programmer... |
PBDJ LATEST STORIES . . . By RIA News Desk  Join Scott Guthrie as he discusses Microsoft’s commitment to web standards development, Rich Internet Applications and how Microsoft is contributing to help move the web forward. Join Adobe’s Kevin Lynch as he demonstrates how Flash and HTML come together to make the most engaging,... | By Bruce Armstrong Particularly in a means of moving PowerBuilder applications to the web. What I’m looking for doesn’t require a server license or the installation of unmanaged code to the web server, and works well across different browsers (not just Internet Explorer). The WPF DataWindow will help... | By PowerBuilder News Desk "The rise of Enterprise Architecture is proof that organizations need to manage the impact of changes in competition, technology and regulations across their enterprise," said Dan Lahl, director of Intelligent Enterprise for Sybase. "PowerDesigner 15's unique Link and Synch technology ... | By Oscar Uriel Tobar Rios  With PowerBuilder 11 Sybase gave developers what we have long hoped for – the possibility of taking an application created in a client/server architecture and turning it into a Web application, almost without having to move the code; and it's better if you don't use a server applicat... | By Maggie Lv  Like any standard .NET application, the PowerBuilder .NET application follows the common language runtime rules regarding the permissions needed to do the operation the application aims to do. The code access security (CAS) provided by the .NET Framework is a security mechanism that a ... | By Abdul Azeez  PowerBuilder 11.0 supports deploying existing PowerBuilder client/server business applications as an ASP.NET WebForm application. This greatly improves developer productivity without having to learn a new development language and preserves PowerBuilder development skills. Although the ... |
SUBSCRIBE TO THE WORLD'S MOST POWERFUL NEWSLETTERS Help Wanted: SYS-CON Media is looking for i-technology reporters, and journalists. Please apply to reporters(at)sys-con.com.
We are also seeking online advertising sales representatives with proven track record. Please apply to careers(at)sys-con.com. |
|
SYS-CON FEATURED WHITEPAPERS BREAKING POWERBUILDER / SYBASE NEWS
Sybase 365, a subsidiary of Sybase, Inc. (NYSE:SY), the global leader in
mobile mes... Oct. 6, 2008 09:14 AM |
 | Join Scott Guthrie as he discusses Microsoft’s commitment to web standards development, Rich Inter... | Particularly in a means of moving PowerBuilder applications to the web. What I’m looking for doesn... | "The rise of Enterprise Architecture is proof that organizations need to manage the impact of change... | With PowerBuilder 11 Sybase gave developers what we have long hoped for – the possibility of takin... | Like any standard .NET application, the PowerBuilder .NET application follows the common language ru... | PowerBuilder 11.0 supports deploying existing PowerBuilder client/server business applications as an... | Virtualization has become a critical part of Enterprise IT strategy. Why and how has it become one o... | Maybe some of you remember a time when we created a sprite on a piece of graph paper and afterwards ... | I have been asked many times by various clients, students, and the IT curious about PowerBuilder: Wh... | PowerBuilder 11's .NET support may be welcomed by developers looking to expand their horizons and ta... | As a long-time PB developer, I have successfully created or maintained many PB applications for clie... | The PowerBuilder 11.5 beta is officially opened. If you're at all interested in upgrading, particula... | AJAX has dominated the web space so extensively that it needs no introduction. Connecting to a serve... | Most new users of PowerBuilder start with SQL Anywhere as the back-end database engine (formerly Ada... | The first is Borland. Originally known for their development tools (e.g., Delphi, JBuilder, C++ Buil... | Even the most sceptical observer would be hard pressed to argue that Sybase isn’t making some smar... | Sybase has announced the immediate availability of the Sybase Analytic Appliance, configured and tun... | Sybase iAnywhere has announced that SQL Anywhere version 11 on Dell PowerEdge has achieved outstandi... | Sybase iAnywhere has announced its new initiative to deliver SQL Anywhere for the web developer comm... | Sybase iAnywhere has announced that SQL Anywhere version 11 is now available to the marketplace. Wit... |
PBDJ PRODUCT REVIEWS By Al Soucy  HarPB is a specialized utility for checking PowerBuilder source objects in and out of AllFusion Harvest. It handles the special requirements of checking objects out ... | By Al Soucy  I began my career at RCA Aerospace and Defense in 1983 and worked at MITRE Corp., BAE Systems, and the State of NH. I worked in the defense field performing software... | By Open Web Developer News Desk In keeping with the longstanding SYS-CON tradition of being at the very forefront of software development with all its online and offline resources, SYS-CON Media & ... |
|
Subscribe to our RSS feeds now and receive the next article instantly!
About Newsfeeds / Video Feeds
.gif)