Home > mysql > Is it common to have stored procedures disabled on MySQL managed hosting plans?

Is it common to have stored procedures disabled on MySQL managed hosting plans?

January 6Hits:1
Advertisement

I'm building an app that I think would benefit from the use of MySQL stored procedures. I know stored procedures have a bad reputation, but I think they suit my application well. Using stored procedures would reduce the number of queries per request significantly (mostly inserts), as well as allow me to leverage the procedures across multiple implementations of this software.

I think the software will benefit. My concern however, is that pushing functionality into stored procedures may make it harder for users to deploy the software on shared hosting services. Is it common practice to expect users to have stored procedure capability (i.e. allow scripts to create and run stored procedures)?

Edit: This application is intended for my end user to deploy on her own.

Answers

I would note that the ability to run stored procedures is a requirement for host of the database for the application into your user requirements documentation if you have a worry about it. Often stored procedures are avoided to allow for different database backends as the different flavors of SQL needed might mean that you have to create different stored procs for each vendor (Complex procs especially tend to use database specific commands). But you seem to be requiring MySQL only anyway, so I would just note it as a system requirement and go on.

Related Articles

  • Is it common to have stored procedures disabled on MySQL managed hosting plans?January 6

    I'm building an app that I think would benefit from the use of MySQL stored procedures. I know stored procedures have a bad reputation, but I think they suit my application well. Using stored procedures would reduce the number of queries per request

  • From SQL Server to NuoDB: Common Table Expressions, Stored Procedures and Bulk UploadsApril 28

    I am currently evaluating NuoDB as a replacement for SQL Server. The application is written in C#, .NET 4.0. Now I am using features of SQL Server like: Common Table Expressions (I have a table with a reference to itself composing a n-level parent-ch

  • Linked tables versus stored procedure performance in MySQLMay 29

    Suppose I have a sub-form, in datasheet view for multiple records, that gives the user full CRUD control over a particular MySQL table. (The records are filtered by the parent-form). Option 1 is to simply create a linked table and set that as the rec

  • "can't return a result set in the given context" error when calling stored procedure - differences between mysql 5.0 and 5.5?February 1

    I have a stored procedure to regenerate leafs (nleft, nright) in simple (id, id_parent) tree. (sample table) When I'am calling CALL EdgeListToNestedSet( 'category', 'id_category', 'id_parent'); it works great with version 5.5.29 of mysql but on 5.0.2

  • How to alter stored procedure in a MySQL database using the Linux command prompt?February 13

    I want to alter the stored procedure in my server machine. I'm uploading the codes via SSH Linux command prompt, I need to alter an existing stored procedure in my server. I don't have c-panel or phpMyAdmin access. I have to update it via a command p

  • Calling a Stored Procedure properly in MySQLJanuary 19

    Here's my Stored Procedure: DELIMITER // CREATE PROCEDURE facturar(codigo int(6),fecha date,cedula VARCHAR(9),cantidad int(3),peso VARCHAR(10),precio varchar(10)) BEGIN DECLARE P float; Declare total float; set P=0; set total=0; insert into factura V

  • SQL Server stored procedure: disable "where" filter if related parameter is not setFebruary 11

    I got a SQL statement which uses some parameters to filter the output. Looking like this: ALTER PROCEDURE [dbo].[spGetPerson] @Vorname varchar(50), @Nachname varchar(50), @FirmaID int, @AbteilungID int, @ArbeitsortID int, @FunktionID int AS BEGIN SET

  • Stored Procedure taking more time to execute (Sql Server 2005)April 24

    I have a stored procedure implemented and calling of this stored proc from web page is taking more than 300ms, But when write the script in the web page and call the url, it is executing in 50ms What are the steps that are required to reduce the time

  • Execute grant for MySQL stored procedure revoked when stored procedure is alteredOctober 30

    I have created the following stored procedure in a MySQL database (MySQL 5.5). DELIMITER $$ CREATE DEFINER=`remote_admin`@`%` PROCEDURE `usp_insert_deal_and_segment`() BEGIN "code here" END$$ This stored procedure is then used by multiple differ

  • Returning a string from a stored procedure C#January 29

    I have written a stored procedure: USE [database] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER PROCEDURE [database table] @StoreNum INT, @CustomerID INT, @r VARCHAR(100) OUTPUT AS BEGIN Select @r = Notes FROM [Database table] WHERE Custo

  • Laravel 5 - Cannot find MySQL Stored ProcedureJanuary 30

    ISSUE: Converting my L4 code to L5.2 and am receiving the following error: SQLSTATE[42000]: Syntax error or access violation: 1305 FUNCTION cr_debug.ENTER_MODULE2 does not exist (SQL: call POPULATE_DAYS_TABLE(20, "01/29/2016")) & SQLSTATE[42

  • Return newly inserted row id from stored procedure using LINQ toSQL

    Return newly inserted row id from stored procedure using LINQ toSQLJanuary 31

    I have a stored procedure as following: ALTER PROCEDURE [dbo].[Addworkshop] @title varchar(100), @time varchar(10), @date date, @mandatory int, @sid int AS BEGIN SET NOCOUNT ON; insert into Workshop(title, date, time, mandatory, sid) values(@title, @

  • Why is sql stored procedure called a stored procedureFebruary 8

    A few days ago I was asked this question(tel intvw) and I was drawn blank. I said execution plan is stored in the server so its called STORED Procedure. But I am not sure I was correct. My research after that has shown that there is plan cache or pro

  • How to check if all the extendend stored procedures (xp_) are enabled or disabled?October 8

    These are the stored procedures that I want to check if they are enabled or disabled. xp_availablemedia xp_cmdshell xp_deletemail xp_dirtree xp_dropwebtask xp_enumerrorlogs xp_enumgroups xp_findnextmsg xp_fixeddrives xp_getnetname xp_logevent xp_logi

  • How to write common stored procedure? January 23

    This question already has an answer here: Stored procedure, pass table name as a parameter 5 answers I wrote two stored procedures in Visual Studio 2010. Both are returning the Id. So the logic is same for both stored procedures. Then how to write a

  • PHPMyAdmin EDIT and EXECUTE buttons disabled for Stored Procedures

    PHPMyAdmin EDIT and EXECUTE buttons disabled for Stored ProceduresFebruary 3

    I created a couple of stored procedures in a remote MySql database (web) a week ago... during the session where I created them I was able to edit them, export them, etc... Now, a week later, I wanted to edit them, and I find that the Edit and Execute

  • Alter table to disable trigger in stored procedureFebruary 10

    If we have an alter table statement within a stored procedure. Will it just affect that session or will it affect all sessions? We use the alter table to disable the triggers that occur because we don't want them run when the stored procedure occurs

  • Disabling Checking of Schema On Function/Stored Procedure CreationSeptember 24

    I'm trying to automate the process that executes changes to the SQL Server 2008 R2 database. The process I put in place drops and recreates my stored procedures and functions, as well as run scripts to change the tables/columns/data. Unfortunately, o

  • Stored Procedures on PHP and Microsoft SQL ServerNovember 26

    Though it's not as common a combination as PHP and MySQL, PHP and Microsoft SQL Server can be a powerful team. You can query SQL Server databases easily and effectively using the PEAR database abstraction layer, just as you would a MySQL database. Bu

  • Syntax check all stored procedures?July 24

    i want to ensure that all stored procedures are still syntatically valid. (This can happen if someone renames/deletes a table/column). Right now my solution to check the syntax of all stored procedures is to go into Enterprise Manager, select the fir

Copyright (C) 2017 ceus-now.com, All Rights Reserved. webmaster#ceus-now.com 14 q. 0.694 s.