<html><div style='background-color:'><P>Hola Yessica, bueno te entiendo con eso de los usuarios tercos, que piden reportes muchas veces un poco complicado por la herramienta que uno utiliza para el desarrollo, te cuento yo desarrollo con PHP y Postgres, y pues el php un poco como que tiene sus limitaciones, y como tu dices hay que ingeniarselas para sacar adelante el proyecto, yo tambien lo pruebo antes en el localhost, pero luego lo subo a mi servidor bueno servidor de la empresa... que esta en Linux y pues el servidor no tengo problemas, pero con lo que si tengo problemas es con las consultas y algunas vistas y me obligaron hasta cierto punto a usar Funciones para que me ayude en algo y pues me ayudo en algo ahh pero lo principal que me faltaban eran definir algunos Indices, mira esta funcion un poco chica bueno se ve grandota por que son varias tablas a la vez : </P>
<DIV>
<P><STRONG>CREATE OR REPLACE FUNCTION "public"."fu_estado_cta_cte" (varchar, varchar, varchar, varchar, date) RETURNS SETOF "public"."estado_cta_cte" AS<BR>$body$<BR>DECLARE<BR> pc_idccodso ALIAS FOR $1;<BR> pc_scrcndni ALIAS FOR $2;<BR> pc_sauccode ALIAS FOR $3;<BR> pc_scrccoso ALIAS FOR $4;<BR> pd_saufecha ALIAS FOR $5;<BR> rd_scoplani estado_cta_cte%rowtype;<BR>begin<BR> <BR> FOR rd_scoplani IN SELECT '' AS idccodpl, det.steccoen AS idccodso,<BR> to_date(eg.stedfech, 'YYYY/MM/DD'::text) AS<BR> sccdfech, 'EGR' AS scctipo, CASE WHEN (det.idccodcu ~~ '5011%'::text)<BR> THEN det.stenmont ELSE 0.00 END AS
sccoapor, CASE WHEN ((det.idccodcu<BR> ~~ '1411%'::text) OR (det.idccodcu ~~ '1412%'::text) OR<BR> (det.idccodcu ~~ '166201'::text)) THEN det.stenmont<BR> ELSE 0::numeric END AS sccopram, CASE WHEN (det.idccodcu ~~<BR> '7331%'::text) THEN det.stenmont ELSE 0::numeric END AS sccoprin, CASE<BR> WHEN (det.idccodcu ~~ '743101%'::text) THEN det.stenmont ELSE<BR> 0::numeric END AS sccoprmo, CASE WHEN (((((det.idccodcu ~~<BR> '1661%'::text) OR (det.idccodcu ~~ '7551%'::text)) AND (det.idccodcu <><BR> '166106'::character varying)) AND (det.idccodcu <>
'166107'::character<BR> varying)) AND (det.idccodcu <> '166108'::character varying)) THEN<BR> det.stenmont ELSE 0::numeric END AS sccoacti, CASE WHEN ((det.idccodcu<BR> = '166106'::character varying) OR (det.idccodcu = '751101'::character<BR> varying)) THEN det.stenmont ELSE 0::numeric END AS sccomant, CASE WHEN<BR> ((det.idccodcu = '166107'::character varying) OR (det.idccodcu =<BR> '757101'::character varying)) THEN det.stenmont ELSE 0::numeric END AS<BR> sccofose, CASE WHEN ((det.idccodcu = '166108'::character varying) OR<BR> (det.idccodcu =
'754101'::character varying)) THEN det.stenmont ELSE<BR> 0::numeric END AS sccomult, det.idcegres AS idcodocu, det.stecsueg AS<BR> idcsucur, CASE WHEN (det.idccodcu = '141401'::character varying) THEN<BR> det.stenmont ELSE 0::numeric END AS sccocred, det.stenafec AS sccodeha, CASE WHEN<BR> (((det.idccodcu = '465102'::character varying) OR (det.idccodcu =<BR> '465101'::character varying)) OR (det.idccodcu = '464101'::character<BR> varying)) THEN det.stenmont ELSE 0::numeric END AS sccootro<BR>FROM stecabeg eg, stedeteg det, scrsocio so WHERE (eg.idcegres = det.idcegres) AND (eg.stecsueg = det.stecsueg)<BR>AND (eg.stectien = det.stectien) AND
(so.idccodso = det.steccoen)<BR>AND eg.stectien = 'SOCIO'::character varying AND det.stectien = 'SOCIO'::character<BR> varying AND eg.anulado = 0::numeric AND eg.eliminar = 0::numeric AND det.steccoen = pc_idccodso<BR>UNION ALL<BR>SELECT '' AS idccodpl, det.steccoen AS idccodso,<BR> to_date(ing.stedfech, 'YYYY/MM/DD'::text) AS<BR> sccdfech, 'ING' AS scctipo, CASE WHEN (det.idccodcu ~~ '5011%'::text)<BR> THEN det.stenmont ELSE 0.00 END AS sccoapor, CASE WHEN (((det.idccodcu<BR> ~~ '1411%'::text) OR (det.idccodcu ~~ '1412%'::text))) THEN det.stenmont ELSE 0::numeric END AS sccopram,<BR> CASE WHEN (det.idccodcu ~~ '7331%'::text) THEN det.stenmont
ELSE<BR> 0::numeric END AS sccoprin, CASE WHEN (det.idccodcu ~~ '743101%'::text)<BR> THEN det.stenmont ELSE 0::numeric END AS sccoprmo, CASE WHEN<BR> (((((det.idccodcu ~~ '1661%'::text) OR (det.idccodcu ~~ '469108%'::text) OR (det.idccodcu ~~ '7551%'::text))<BR> AND (det.idccodcu <> '166106'::character varying)) AND (det.idccodcu <><BR> '166107'::character varying)) AND (det.idccodcu <> '166108'::character<BR> varying)) THEN det.stenmont ELSE 0::numeric END AS sccoacti, CASE WHEN<BR> ((det.idccodcu = '166106'::character varying) OR (det.idccodcu
=<BR> '751101'::character varying)) THEN det.stenmont ELSE 0::numeric END AS<BR> sccomant, CASE WHEN ((det.idccodcu = '166107'::character varying) OR<BR> (det.idccodcu = '757101'::character varying)) THEN det.stenmont ELSE<BR> 0::numeric END AS sccofose, CASE WHEN ((det.idccodcu =<BR> '166108'::character varying) OR (det.idccodcu = '754101'::character<BR> varying)) THEN det.stenmont ELSE 0::numeric END AS sccomult,<BR> det.idcingre AS idcodocu, ing.idcsucur, CASE WHEN ((det.idccodcu ~~<BR> '1413%'::text) OR (det.idccodcu ~~ '1414%'::text)) THEN
det.stenmont<BR> ELSE 0::numeric END AS sccocred, det.stenafec AS sccodeha, CASE WHEN<BR> (((det.idccodcu = '465102'::character varying) OR (det.idccodcu =<BR> '465101'::character varying)) OR (det.idccodcu = '464101'::character<BR> varying) OR (det.idccodcu ~~ '751201%'::text))<BR> THEN det.stenmont ELSE 0::numeric END AS sccootro<BR>FROM stecabin ing, stedetin det, scrsocio so WHERE (ing.idcingre = det.idcingre) AND<BR>(ing.stectien = det.stectien) AND (ing.idcsucur = det.idcsucur) AND (so.idccodso = det.steccoen)<BR>AND ing.stectien = 'SOCIO'::character varying AND det.stectien = 'SOCIO'::character varying AND ing.eliminar = 0::numeric AND ing.anulado =
0::numeric<BR> AND det.steccoen = pc_idccodso<BR>UNION ALL<BR> SELECT pl.idccodpl, pl.idccodso, pl.sccdfech, pl.sccctipo AS scctipo,<BR> pl.sccoapor, pl.sccopram, pl.sccoprin, pl.sccoprmo, pl.sccoacti,<BR> pl.sccomant, pl.sccofose, pl.sccomult, '' AS idcodocu, '' AS idcsucur,<BR> pl.sccocred, 0 AS sccodeha, CASE WHEN pl.scondein IS NULL THEN 0.00 ELSE pl.scondein END AS sccootro<BR> FROM scoplani pl WHERE pl.idccodso = pc_idccodso<BR>UNION ALL<BR>SELECT '' AS idccodpl, ord.idccodso, ord.scrdfech AS sccdfech, 'BOLE' AS<BR> scctipo, 0 AS sccoapor, 0 AS sccopram, 0 AS sccoprin, 0 AS sccoprmo, 0 AS<BR> sccoacti, 0 AS sccomant, 0 AS
sccofose, 0 AS sccomult, (<BR> SELECT ((((scrcabbo.scrcseri || '-'::character varying) ||<BR> scrcabbo.scrcnume) || '-'::character varying) || scrcabbo.idccodbo)<BR> WHERE (((scrcabbo.idccodbo = ord.idccodbo) AND (scrcabbo.eliminar =<BR> 0::numeric)) AND (scrcabbo.scrnanul = 0::numeric) AND scrcabbo.idccodso = pc_idccodso)<BR> ) AS idcodocu, ord.idcsucur, CASE WHEN (ord.scrctipo = 'OCTO2'::character<BR> varying) THEN (<BR> SELECT scrcabbo.scrntota<BR> FROM scrcabbo<BR> WHERE (((scrcabbo.idccodbo = ord.idccodbo) AND (scrcabbo.eliminar =<BR> 0::numeric)) AND (scrcabbo.scrnanul = 0::numeric) AND scrcabbo.idccodso =
pc_idccodso)<BR> ) ELSE 0::numeric END AS sccocred, 0 AS sccodeha, 0 AS sccootro<BR>FROM scrordcr ord<BR>WHERE ord.scrctipo = 'OCTO2'::character varying AND ord.scrnesta =<BR> 1::numeric AND ord.eliminar = 0::numeric AND ord.anulado = 0::numeric AND ord.idccodso = pc_idccodso<BR>UNION ALL<BR>SELECT '' AS idccodpl, ord.idccodso, ord.scrdfech AS sccdfech, 'CRED' AS<BR> scctipo, 0 AS sccoapor, 0 AS sccopram, 0 AS sccoprin, 0 AS sccoprmo, 0 AS<BR> sccoacti, 0 AS sccomant, 0 AS sccofose, 0 AS sccomult, ord.idccodoc AS<BR> idcodocu, ord.idcsucur, ord.scrnmoau AS sccocred, 0 AS sccodeha, 0 AS sccootro<BR>FROM scrordcd ord<BR>WHERE ord.scrnesta = 0::numeric AND ord.eliminar = 0::numeric AND ord.anulado = 0::numeric<BR>AND ord.idccodso = pc_idccodso<BR>UNION ALL<BR>SELECT '' AS idccodpl, det.sccccoen AS
idccodso,<BR> asi.sccdfech, 'TRAN' AS scctipo, CASE WHEN (det.idccodcu ~~<BR> '5011%'::text) THEN det.sccnmont ELSE 0.00 END AS sccoapor, CASE WHEN<BR> ((det.idccodcu ~~ '1411%'::text) OR (det.idccodcu ~~ '1412%'::text)<BR> OR (det.idccodcu ~~ '166201%'::text))<BR> THEN det.sccnmont ELSE 0::numeric END AS sccopram, CASE WHEN<BR> (det.idccodcu ~~ '7331%'::text) THEN det.sccnmont ELSE 0::numeric END<BR> AS sccoprin, CASE WHEN (det.idccodcu ~~ '743101%'::text) THEN<BR> det.sccnmont ELSE 0::numeric END AS sccoprmo, CASE
WHEN<BR> (((((det.idccodcu ~~ '1661%'::text) OR (det.idccodcu ~~ '7551%'::text))<BR> AND (det.idccodcu <> '166106'::character varying)) AND (det.idccodcu <><BR> '166107'::character varying)) AND (det.idccodcu <> '166108'::character<BR> varying)) THEN det.sccnmont ELSE 0::numeric END AS sccoacti, CASE WHEN<BR> ((det.idccodcu = '166106'::character varying) OR (det.idccodcu =<BR> '751101'::character varying)) THEN det.sccnmont ELSE 0::numeric END AS<BR> sccomant, CASE WHEN ((det.idccodcu = '166107'::character varying) OR<BR> (det.idccodcu =
'757101'::character varying)) THEN det.sccnmont ELSE<BR> 0::numeric END AS sccofose, CASE WHEN ((det.idccodcu =<BR> '166108'::character varying) OR (det.idccodcu = '754101'::character<BR> varying)) THEN det.sccnmont ELSE 0::numeric END AS sccomult,<BR> det.idccodas AS idcodocu, asi.idcsucur, CASE WHEN ((det.idccodcu ~~<BR> '1413%'::text) OR (det.idccodcu ~~ '1414%'::text)) THEN det.sccnmont<BR> ELSE 0::numeric END AS sccocred, det.sccnafec AS sccodeha, CASE WHEN<BR> (((det.idccodcu = '465102'::character varying) OR (det.idccodcu =<BR> '465101'::character
varying)) OR (det.idccodcu = '464101'::character<BR> varying)) THEN det.sccnmont ELSE 0::numeric END AS sccootro<BR>FROM (scccabas asi JOIN sccdetas det ON ((asi.idccodas = det.idccodas)))<BR>WHERE upper((asi.sccctiop)::text) = 'AT'::text AND det.idccodtd = '038'::character varying AND asi.eliminar = 0::numeric AND asi.sccnanul = 0::numeric AND det.sccccoen = pc_idccodso LOOP<BR> RETURN NEXT rd_scoplani;<BR> END LOOP;<BR> RETURN;<BR>END<BR>$body$<BR>LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER;</STRONG><BR><BR>bueno te la paso completa pa que la veas y como veras asi hay muchas mas pero resulta que algunas vistas que tengo se demoran mucho en mostrar y muchas veces el navegador me bota del sistema se corta es un error muy comun que tengo en estos
dias, necesito ayudaaaaaa!!!!!!! Urgente, quisiera saber cual se ejecuta mas rapido una funcion a la que le envio parametros y me retorna ragistros o un vista haber si me puedes ayudar.</P>
<P>suelo escribir muy poco siempre jejeje gracias bye</P><BR><BR><BR>
<DIV>
<P align=right><FONT face="Lucida Handwriting, Cursive" color=#0099cc size=1><STRONG>El amor es el significado último de todo lo que nos rodea. No es un simple sentimiento, es la verdad, es la alegría que está en el origen de toda creación. </STRONG></FONT><FONT face="Lucida Handwriting, Cursive" color=#ff0000 size=1><STRONG><IMG height=2 src="http://graphics.hotmail.com/greypixel.gif" width="100%" vspace=9>.:: J @ v i e r ::.</STRONG></FONT></P></DIV></DIV></div></html>
