?????? Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
As I consult the oracle 9i reference , I found they actualy have values of 'similar' and 'force' to be set for cursor_shareing parameter, which allows oracle to treat hard-coded statements to bind-variable statements in order to use the same execution plans. I wonder how they do this?...>_;

gmane

2012-08-13 Thread Thufir
Looking at: Group gmane.comp.db.mysql.general Description The main list for general MySQL discussion Address mysql@... Status posting allowed http://dir.gmane.org/gmane.comp.db.mysql.general It would really be nice if posting were actually allowed, but apparently this is not the

javax.mail.Message

2012-08-13 Thread Thufir
I'm using the GNU NNTP API to connect to a NNTP server, leafnode, running on localhost. This API uses javax.mail.Message and there's no convenient way to lookup a specific Message without opening a Folder and searching through the messages, which is fine for a small number of articles, but not

Re: real Time

2012-08-13 Thread Michael Anderson
Look at Nodejs, asynchronous server-side programming environment. That combined with some basic MySql triggers could do it for you. On 08/13/2012 04:07 PM, Rafael Valenzuela wrote: Hi all, i've a question about the mysql configuration, in my project, we need use data in real time (read and ins

real Time

2012-08-13 Thread Rafael Valenzuela
Hi all, i've a question about the mysql configuration, in my project, we need use data in real time (read and insert) . But i don't idea about this matter. Any advice or information? i'm so sorry the hassle. -- Mit forever My Blog My Faborite Web

Re: Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread Johan De Meersman
- Original Message - > From: "MID.night" <693893...@qq.com> > > Like select * from table where name>’A’ is just > > The same as select * from table where name>’B’. The execution plan for both statements is indeed likely (but not guaranteed!) to be the same. As far as I'm aware, thoug

ANN: Database Workbench 4.3.0, the multi-DBMS IDE now available!

2012-08-13 Thread Martijn Tonies
com/go/?go=news&id=20120813 The FREE Lite Editions will follow later. Changes include: - NEW: Stored Procedure & Trigger debugger for MySQL - NEW: incremental data search in SQL, Table & View Editor - FIXED: Oracle Debugger fixes - FIXED: NexusDB error when testing Stored Functions - F

Hi, how did u do de-emphasis of sql statements?

2012-08-13 Thread MID.night
Hey man, I would like to ask a question about de-emphasis of sql statements? I Mean mysql engines have to be aware of which two statements are exactly the same Despite of variables?? values at runtime. Because in slow log, the execution counter is Maintained for each sql statement. De-emphas