[Info-Ingres] #ingres IRC channel on freenode.net

DATABASE

    Sponsored Links

    Next

  • 1. test
    This is a multi-part message in MIME format... ------=_NextPart_000_0011_A1BBB606.9A85E761-- This is a multi-part message in MIME format... ?w?U!?{jx'fG*s3C??5^5tH?e2$CK $&?TY<^<8N??W~?YPi?RyTn7? N(?pXJjV?j?V{/{"2Ae<}?e3wlYe?$Br0k7<ya?6Vo?FR]J:l<\{qT1L*? B?Z?}zb#?)ba~X?Efg?7{,06fD{V_)??}?>qH6?9)??O?t%oa[|w1c/ ,ST Y"$?P??X?L?erzi-Iv39^a]Oz5?~ k??gem?>(?qt_Zf/V)DK'|Rt ?e&?1?[%?0E[eh]E~I???}.(\ls?D?E?36? dX>FC))Z<b{?/?o/p18qz{QJB D?NF0? 4iG' {C%DH'a3zdr\2?M?K? *?N9?iW?>6]<?mUs?l 1uGn>a[`3?<?7f?,c#wA/?k3i*r:ra6B`:JnEMV?IW89)|?(Ypa? 2Q/*h?5HVX-X?"{?

Re: [Info-Ingres] #ingres IRC channel on freenode.net

Postby James K. Lowden » Wed, 26 Mar 2008 09:39:40 GMT


...

The two are complementary, like the post and the telephone.  

I'm not a big IRC guy because I like the asychronicity of email, and I
agree with Roy that Ingres at this point is better off with one email
channel.  But the immediacy of IRC can be useful in its own right, and
will help the larger community if its denizens make the effort to forward
any useful outcomes to the mailing list.  

--jkl

Re: [Info-Ingres] #ingres IRC channel on freenode.net

Postby Grant Croker » Wed, 26 Mar 2008 18:19:33 GMT




I completely agree - IRC has its place and is easier to co-ordinate than 
say one of the many instant messenger clients out there. If there is 
going to be some real-time discussion going on better to have a known 
meeting point.

g

-- 
Grant Croker - Ingres PHP, Ruby and Python maintainer
The teacher usually learns more than the pupils. Isn't that true? 
"It would be hard to learn much less than my pupils," came a low growl
from somewhere on the table, "without undergoing a pre-frontal
lobotomy."


Re: [Info-Ingres] #ingres IRC channel on freenode.net

Postby Martin Bowes » Wed, 26 Mar 2008 23:32:11 GMT

Hi Steve,

What did you look for on the community Wiki and why didn't it float your
boat?

I would have said that the wiki and comp.databases.ingres have two
different purposes in my mind. The wiki is more set towards the
Opensource side of things, there are certainly some interesting code
examples in there (particularly the ones I've installed) that may be of
general usage. But by and large, general queries along the lines of "why
does this query's  performance suck" are to be handled in cdi or
info-ingres. The Wiki won't address those.


Ditto. 

Martin Bowes


Similar Threads:

1.#ingres IRC channel on freenode.net

Hi Everyone,

By popular request, I have created a #ingres channel on
irc.freenode.net. I invite you to join me in the channel.

You can do so with any number of IRC clients (including free ones) as
well as a number of web sites offering free access.

Enjoy,

Andrew

2.[Info-Ingres] #ingres IRC logs

3.[Info-ingres] Calling Ingres Database Procedures through .Net Data Provider

This is a multi-part message in MIME format.

Ingres r3 supports row-producing procedures.  The Ingres .NET Data
Provider reads the result set produced by that procedure just as any
result set produced by a query.

 

If the procedure is something like this:

 

drop procedure rowproc \p\g

 

create procedure rowproc

   result row(char(32)) as

declare tabname char(32);

begin

   for select table_name into :tabname from iitables

   do

      return row(:tabname);

   endfor;

end;

\p\g

 

The .NET application would execute the procedure and read the result set
like this:

 

            IDataReader reader = null;

      cmd = new IngresCommand(

            "rowproc", conn, txn); //"{ call rowproc}", conn, txn);

      cmd.CommandType = CommandType.StoredProcedure;

      reader = cmd.ExecuteReader();

 

      Console.Write("ColumnName='" + reader.GetName(0) + "'");

      Console.WriteLine();

 

      while (reader.Read())

      {

            Console.Write(reader.GetString(0) + "\t");

      }

      Console.WriteLine();

      reader.Close();

 

Hope this helps,

Dave


<html>

<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 11 (filtered)">
<style>
<!--
 /* Style Definitions */
 p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0in;
	margin-bottom:.0001pt;
	font-size:12.0pt;
	font-family:"Times New Roman";}
a:link, span.MsoHyperlink
	{color:blue;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{color:#606420;
	text-decoration:underline;}
span.EmailStyle17
	{font-family:Arial;
	color:windowtext;}
@page Section1
	{size:8.5in 11.0in;
	margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
	{page:Section1;}
-->
</style>

</head>

<body lang=EN-US link=blue vlink="#606420">

<div class=Section1>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Ingres r3 supports row-producing procedures.  The
Ingres .NET Data Provider reads the result set produced by that procedure just
as any result set produced by a query.</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>If the procedure is something like this:</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>drop procedure rowproc \p\g</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'> </span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>create procedure rowproc</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   result row(char(32)) as</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>declare tabname char(32);</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>begin</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   for select table_name
into :tabname from iitables</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   do</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>     
return row(:tabname);</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>   endfor;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>end;</span></font></p>

<p class=MsoNormal style='margin-left:.5in'><font size=2 face=Arial><span
style='font-size:10.0pt;font-family:Arial'>\p\g</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>The .NET application would execute the procedure and read the
result set like this:</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>           
</span></font><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>IDataReader reader = null;</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      cmd
= <font color=blue><span style='color:blue'>new</span></font> IngresCommand(</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>            "rowproc",
conn, txn); <font color=green><span style='color:green'>//"{ call
rowproc}", conn, txn);</span></font></span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      cmd.CommandType
= CommandType.StoredProcedure;</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      reader
= cmd.ExecuteReader();</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.Write("ColumnName='"
+ reader.GetName(0) + "'");</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.WriteLine();</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      <font
color=blue><span style='color:blue'>while</span></font> (reader.Read())</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      {</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>            Console.Write(reader.GetString(0)
+ "\t");</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      }</span></font></p>

<p class=MsoNormal style='text-autospace:none'><font size=2 face="Courier New"><span
style='font-size:10.0pt;font-family:"Courier New"'>      Console.WriteLine();</span></font></p>

<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'>      reader.Close();</span></font></p>

<p class=MsoNormal><font size=2 face="Courier New"><span style='font-size:10.0pt;
font-family:"Courier New"'> </span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Hope this helps,</span></font></p>

<p class=MsoNormal><font size=2 face=Arial><span style='font-size:10.0pt;
font-family:Arial'>Dave</span></font></p>

</div>

</body>

</html>

4.[Info-Ingres] Ingres .Net data provider and VS 2005 Data Sources

5.[Info-Ingres] Ingres Net and performance

Hi all:
I have Ingres 2006 r2 Ingres Vision applications running on a RHEL 4 64 
bits running against Ingres 2.6 sp5 on Tru64 machine (using Ingres Net + 
installation password).
Before this scenario, Ingres Vision applications were running on the 
same tru64 DBMS Local hosts. On this old scenario my batch processes 
were better peformance than with the new one (client/server).
I know that Ingres Net is a player here for performance degradation. 
What I need to know if is there any Ingres net configuration parameter 
or Linux/Tru64 OS parameters that I need to modify in order to increase 
my batch processes performance

Any help will be appreciate

Oscar

PD: I have a gigabit connection between servers

-- 
Lic. Oscar Carl Barriocanal
Director de Servicios al Cliente
tegra S.R.L.
Telefax: (595 21) 424473 RA
Asunci - Paraguay



6. [Info-Ingres] Ingres 2006 Net Enterprise Edition

7. [Info-ingres] Ingres 2.5 Net Client: Faulting Application iijdbc.exe

8. [Info-ingres] Visual Studio and Ingres .Net Providers



Return to DATABASE

 

Who is online

Users browsing this forum: No registered users and 37 guest