MySqlTalk.com  

Go Back   MySqlTalk.com > MySQL > General
User Name
Password
FAQ Members List Calendar Search Today's Posts Mark Forums Read


Reply
 
Thread Tools Search this Thread
Old 08-30-2005, 07:23 PM   #11
Azkaban
Senior Member
 
Join Date: Jul 2004
Posts: 167 Azkaban is on a distinguished road
Re: MySQL performance

I did have to read your post in two sittings, but surprisingly the only thing I didn't understand was when you said
Quote:
It did, but the DBI would mysteriously die in the execute() after an execute() that called an SP

What is an SP?

And in case you didn't know, you, my friend, are a geek's geek. Pshaw, nonshalantly mentioning that coding a sniffer is not that easy? Really? Some people find using a sniffer not that easy

That is quite an impressive description of your recent work. I'm sure Google or Yahoo would snap you up with a huge salary and significant shares in a shot.
Azkaban is offline   Fork this post Reply With Quote
Old 08-31-2005, 11:20 AM   #12
codenode
Member
 
Join Date: Nov 2004
Posts: 31 codenode is on a distinguished road
Re: MySQL performance

SP means Store Procedure (http://dev.mysql.com/doc/mysql/en/st...ocedures.html). They're quite nice, but rather new in the MySQL world so some MySQL client interfaces (like Perl DBD::mysql and the regular PHP/MySQL) don't support them. PHP supposedly does if you recompile it to use the new PHP/MySQL interface, mysqli.
codenode is offline   Fork this post Reply With Quote
Old 09-01-2005, 02:59 PM   #13
Norom
Junior Member
 
Join Date: Sep 2005
Posts: 6 Norom is on a distinguished road
Re: MySQL performance

So mysqli is client side? Or is it like phpmyadmin?
Norom is offline   Fork this post Reply With Quote
Old 09-05-2005, 03:54 PM   #14
Azkaban
Senior Member
 
Join Date: Jul 2004
Posts: 167 Azkaban is on a distinguished road
Re: MySQL performance

Quote:
Originally Posted by codenode
SP means Store Procedure (http://dev.mysql.com/doc/mysql/en/st...ocedures.html). They're quite nice, but rather new in the MySQL world so some MySQL client interfaces (like Perl DBD::mysql and the regular PHP/MySQL) don't support them. PHP supposedly does if you recompile it to use the new PHP/MySQL interface, mysqli.
Interesting. If you're not in a shared environment with different languages, is security the only major feature? How helpful is it? Is the idea to develop using the full statements and then building your apps with every database call as a stored procedure? Sounds like a lot of extra work. Unless I am missing how it is implemented? Because if you don't force all sql calls into stored procedures, the client still has access to the database tables.
Azkaban is offline   Fork this post Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Access, Excel and data of other formats to MySQL by Navicat NavicatGuy Articles 0 08-17-2004 01:08 AM
3.2 Entering Queries Administrator Documentation 0 06-09-2004 02:58 AM
1.4.3.2 Using the MySQL Software for Free Under GPL Administrator Documentation 0 06-08-2004 02:20 AM
1.2.2 The Main Features of MySQL Administrator Documentation 0 06-08-2004 01:55 AM
1.2 Overview of the MySQL Database Management System Administrator Documentation 0 06-07-2004 10:11 PM



All times are GMT -4. The time now is 06:51 AM.



Powered by: vBulletin, Copyright ©2000 - 2008, Jelsoft Enterprises Limited.
Google
  Web http://www.mysqltalk.com
DISCLAIMERS:
1. We have no commercial interest in this site.
Banner Ads and Subscriptions will only be used to help pay for hosting and maintenance costs.
2. MySQLTalk.com is NOT affiliated with MySQL AB in any way.
3. MySQLTalk.com is NOT endorsed by MySQL AB in any way.
4. Please do not post any content that is harmful to MySQL or MySQL AB, meaning no misleading or obsolete information will be tolerated.
Well-founded constructive criticism meant to help the community is permitted.
5. This website is founded with the goal of improving the MySQL community.
We not only tolerate newbies, we encourage them.
Please do not ask newbies to "read the manual".