Forums Últimos mensajes - Powered by IBM
 
Tags Palabras claves

Para Miguel Egea (Imprsion en SQL)

26/07/2003 - 01:10 por Isaías | Informe spam
Ayuda Hacer una pregunta
Te expongo los estadisticos que me pediste para revisar la
razon por la cual se vuelve un caos la impresion de
boletos en mi aplicación, espero tus comentarios:

Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 30,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 0, logical reads 28,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 168,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
ANI FECHA MINUTOS DNIS CONSE
01-6737327869 2003-07-25 16:52:00 191845
01-4777764559 2003-07-25 16:52:00 191847
01-8688240799 2003-07-25 16:52:00 191848
01-8183880608 2003-07-25 16:52:00 191849
01-2222647171 2003-07-25 16:52:00 191850
01-3747420137 2003-07-25 16:52:00 191851
01-3338614151 2003-07-25 16:52:00 191853
01-9535514004 2003-07-25 16:52:00 191854
01-4499730935 2003-07-25 16:52:00 191855
01-7221505477 2003-07-25 16:52:00 191856
01-7444431362 2003-07-25 16:52:00 191857
01-8183765841 2003-07-25 16:52:00 191858
01-3414127311 2003-07-25 16:52:00 191859
01-9383842778 2003-07-25 16:52:00 191860
01-8666971263 2003-07-25 16:52:00 191861
01-8717179228 2003-07-25 16:52:00 191862
01-7626210374 2003-07-25 16:52:00 191863
01-3338257083 2003-07-25 16:52:00 191864
01-3939352246 2003-07-25 16:52:00 191865
01-3336710714 2003-07-25 16:52:00 191866
01-8717250405 2003-07-25 16:52:00 191867
01-6969614034 2003-07-25 16:52:00 191868
01-9999273910 2003-07-25 16:52:00 191869
01-8332166163 2003-07-25 16:52:00 191870
01-6444180747 2003-07-25 16:52:00 191871
01-8181400943 2003-07-25 16:52:00 191872
01-3336651373 2003-07-25 16:52:00 191873

Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.
email Siga el debateRespuesta 9 respuestasRespuesta Tengo una respuesta

Preguntas similare

Leer las respuestas

#6 Miguel Egea
30/07/2003 - 08:52 | Informe spam
Isaías tiene un servidor de impresión que usa cristal para imprimir unos
recibos.

Espero que te sirva.

Saludos
Miguel Egea
PortalSLQ
http://www.configuracionesintegrales.com/miguele
Sql-Server MVP
"Eladio Rincón" escribió en el mensaje
news:#
Hola Isaias,

cual es el inicio del thread, please?

Eladio Rincón
MCP, SQL Server MVP
http://eu.webmatrixhosting.net/Eladio

"Comparte lo que sabes, aprende lo que no sepas." FGG

"Isaías" escribió en el mensaje
news:033c01c35301$fdfec1f0$
Te expongo los estadisticos que me pediste para revisar la
razon por la cual se vuelve un caos la impresion de
boletos en mi aplicación, espero tus comentarios:

Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 30,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 0, logical reads 28,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 168,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
ANI FECHA MINUTOS DNIS CONSE
01-6737327869 2003-07-25 16:52:00 191845
01-4777764559 2003-07-25 16:52:00 191847
01-8688240799 2003-07-25 16:52:00 191848
01-8183880608 2003-07-25 16:52:00 191849
01-2222647171 2003-07-25 16:52:00 191850
01-3747420137 2003-07-25 16:52:00 191851
01-3338614151 2003-07-25 16:52:00 191853
01-9535514004 2003-07-25 16:52:00 191854
01-4499730935 2003-07-25 16:52:00 191855
01-7221505477 2003-07-25 16:52:00 191856
01-7444431362 2003-07-25 16:52:00 191857
01-8183765841 2003-07-25 16:52:00 191858
01-3414127311 2003-07-25 16:52:00 191859
01-9383842778 2003-07-25 16:52:00 191860
01-8666971263 2003-07-25 16:52:00 191861
01-8717179228 2003-07-25 16:52:00 191862
01-7626210374 2003-07-25 16:52:00 191863
01-3338257083 2003-07-25 16:52:00 191864
01-3939352246 2003-07-25 16:52:00 191865
01-3336710714 2003-07-25 16:52:00 191866
01-8717250405 2003-07-25 16:52:00 191867
01-6969614034 2003-07-25 16:52:00 191868
01-9999273910 2003-07-25 16:52:00 191869
01-8332166163 2003-07-25 16:52:00 191870
01-6444180747 2003-07-25 16:52:00 191871
01-8181400943 2003-07-25 16:52:00 191872
01-3336651373 2003-07-25 16:52:00 191873

Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.


Respuesta Responder a este mensaje
#7 Miguel Egea
30/07/2003 - 08:52 | Informe spam
Hola Isaías, una cosa que pasé por alto ¿Este procedimiento lo llamas una
vez por cada recibo?



Espero que te sirva.

Saludos
Miguel Egea
PortalSLQ
http://www.configuracionesintegrales.com/miguele
Sql-Server MVP
"Isaías" escribió en el mensaje
news:033c01c35301$fdfec1f0$
Te expongo los estadisticos que me pediste para revisar la
razon por la cual se vuelve un caos la impresion de
boletos en mi aplicación, espero tus comentarios:

Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 30,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 0, logical reads 28,
physical reads 0, read-ahead reads 0.
Table 'FILE_1507'. Scan count 1, logical reads 168,
physical reads 0, read-ahead reads 0.
Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.
Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
physical reads 0, read-ahead reads 0.
ANI FECHA MINUTOS DNIS CONSE
01-6737327869 2003-07-25 16:52:00 191845
01-4777764559 2003-07-25 16:52:00 191847
01-8688240799 2003-07-25 16:52:00 191848
01-8183880608 2003-07-25 16:52:00 191849
01-2222647171 2003-07-25 16:52:00 191850
01-3747420137 2003-07-25 16:52:00 191851
01-3338614151 2003-07-25 16:52:00 191853
01-9535514004 2003-07-25 16:52:00 191854
01-4499730935 2003-07-25 16:52:00 191855
01-7221505477 2003-07-25 16:52:00 191856
01-7444431362 2003-07-25 16:52:00 191857
01-8183765841 2003-07-25 16:52:00 191858
01-3414127311 2003-07-25 16:52:00 191859
01-9383842778 2003-07-25 16:52:00 191860
01-8666971263 2003-07-25 16:52:00 191861
01-8717179228 2003-07-25 16:52:00 191862
01-7626210374 2003-07-25 16:52:00 191863
01-3338257083 2003-07-25 16:52:00 191864
01-3939352246 2003-07-25 16:52:00 191865
01-3336710714 2003-07-25 16:52:00 191866
01-8717250405 2003-07-25 16:52:00 191867
01-6969614034 2003-07-25 16:52:00 191868
01-9999273910 2003-07-25 16:52:00 191869
01-8332166163 2003-07-25 16:52:00 191870
01-6444180747 2003-07-25 16:52:00 191871
01-8181400943 2003-07-25 16:52:00 191872
01-3336651373 2003-07-25 16:52:00 191873

Table '#Imp56______________________________________________
___________________________________________________________
_____000300026923'. Scan count 1, logical reads 1,
physical reads 0, read-ahead reads 0.
Respuesta Responder a este mensaje
#8 Eladio Rincón
30/07/2003 - 16:49 | Informe spam
Y al final cual es el problema? es el servidor de impresión?

Eladio Rincón
MCP, SQL Server MVP
http://eu.webmatrixhosting.net/Eladio

"Comparte lo que sabes, aprende lo que no sepas." FGG

"Miguel Egea" escribió en el mensaje
news:
Isaías tiene un servidor de impresión que usa cristal para imprimir unos
recibos.

Espero que te sirva.

Saludos
Miguel Egea
PortalSLQ
http://www.configuracionesintegrales.com/miguele
Sql-Server MVP
"Eladio Rincón" escribió en el mensaje
news:#
> Hola Isaias,
>
> cual es el inicio del thread, please?
>
> Eladio Rincón
> MCP, SQL Server MVP
> http://eu.webmatrixhosting.net/Eladio
>
> "Comparte lo que sabes, aprende lo que no sepas." FGG
>
> "Isaías" escribió en el mensaje
> news:033c01c35301$fdfec1f0$
> Te expongo los estadisticos que me pediste para revisar la
> razon por la cual se vuelve un caos la impresion de
> boletos en mi aplicación, espero tus comentarios:
>
> Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
> physical reads 0, read-ahead reads 0.
> Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
> physical reads 0, read-ahead reads 0.
> Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> physical reads 0, read-ahead reads 0.
> Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> physical reads 0, read-ahead reads 0.
> Table 'FILE_1507'. Scan count 1, logical reads 30,
> physical reads 0, read-ahead reads 0.
> Table '#Imp56______________________________________________
> ___________________________________________________________
> _____000300026923'. Scan count 0, logical reads 28,
> physical reads 0, read-ahead reads 0.
> Table 'FILE_1507'. Scan count 1, logical reads 168,
> physical reads 0, read-ahead reads 0.
> Table '#Imp56______________________________________________
> ___________________________________________________________
> _____000300026923'. Scan count 1, logical reads 1,
> physical reads 0, read-ahead reads 0.
> Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> physical reads 0, read-ahead reads 0.
> ANI FECHA MINUTOS DNIS CONSE
> 01-6737327869 2003-07-25 16:52:00 191845
> 01-4777764559 2003-07-25 16:52:00 191847
> 01-8688240799 2003-07-25 16:52:00 191848
> 01-8183880608 2003-07-25 16:52:00 191849
> 01-2222647171 2003-07-25 16:52:00 191850
> 01-3747420137 2003-07-25 16:52:00 191851
> 01-3338614151 2003-07-25 16:52:00 191853
> 01-9535514004 2003-07-25 16:52:00 191854
> 01-4499730935 2003-07-25 16:52:00 191855
> 01-7221505477 2003-07-25 16:52:00 191856
> 01-7444431362 2003-07-25 16:52:00 191857
> 01-8183765841 2003-07-25 16:52:00 191858
> 01-3414127311 2003-07-25 16:52:00 191859
> 01-9383842778 2003-07-25 16:52:00 191860
> 01-8666971263 2003-07-25 16:52:00 191861
> 01-8717179228 2003-07-25 16:52:00 191862
> 01-7626210374 2003-07-25 16:52:00 191863
> 01-3338257083 2003-07-25 16:52:00 191864
> 01-3939352246 2003-07-25 16:52:00 191865
> 01-3336710714 2003-07-25 16:52:00 191866
> 01-8717250405 2003-07-25 16:52:00 191867
> 01-6969614034 2003-07-25 16:52:00 191868
> 01-9999273910 2003-07-25 16:52:00 191869
> 01-8332166163 2003-07-25 16:52:00 191870
> 01-6444180747 2003-07-25 16:52:00 191871
> 01-8181400943 2003-07-25 16:52:00 191872
> 01-3336651373 2003-07-25 16:52:00 191873
>
> Table '#Imp56______________________________________________
> ___________________________________________________________
> _____000300026923'. Scan count 1, logical reads 1,
> physical reads 0, read-ahead reads 0.
>
>


Respuesta Responder a este mensaje
#9 Miguel Egea
30/07/2003 - 17:10 | Informe spam
Pues yo creo que el sp no es, al menos si eso es para generar todos los
informes, si los genera uno a uno es otra cosa, quizá se pueda cambiar la
estrategia para generar todos los recibos en un solo sp y que sea cristal el
que los parta con saltso de pagina

Saludos
Miguel Egea
http://www.portalsql.com
SQL-Server MVP
"Eladio Rincón" escribió en el mensaje
news:#
Y al final cual es el problema? es el servidor de impresión?

Eladio Rincón
MCP, SQL Server MVP
http://eu.webmatrixhosting.net/Eladio

"Comparte lo que sabes, aprende lo que no sepas." FGG

"Miguel Egea" escribió en el mensaje
news:
> Isaías tiene un servidor de impresión que usa cristal para imprimir unos
> recibos.
>
> Espero que te sirva.
>
> Saludos
> Miguel Egea
> PortalSLQ
> http://www.configuracionesintegrales.com/miguele
> Sql-Server MVP
> "Eladio Rincón" escribió en el mensaje
> news:#
> > Hola Isaias,
> >
> > cual es el inicio del thread, please?
> >
> > Eladio Rincón
> > MCP, SQL Server MVP
> > http://eu.webmatrixhosting.net/Eladio
> >
> > "Comparte lo que sabes, aprende lo que no sepas." FGG
> >
> > "Isaías" escribió en el mensaje
> > news:033c01c35301$fdfec1f0$
> > Te expongo los estadisticos que me pediste para revisar la
> > razon por la cual se vuelve un caos la impresion de
> > boletos en mi aplicación, espero tus comentarios:
> >
> > Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
> > physical reads 0, read-ahead reads 0.
> > Table 'CONTEST_LIST'. Scan count 1, logical reads 3,
> > physical reads 0, read-ahead reads 0.
> > Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> > physical reads 0, read-ahead reads 0.
> > Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> > physical reads 0, read-ahead reads 0.
> > Table 'FILE_1507'. Scan count 1, logical reads 30,
> > physical reads 0, read-ahead reads 0.
> > Table '#Imp56______________________________________________
> > ___________________________________________________________
> > _____000300026923'. Scan count 0, logical reads 28,
> > physical reads 0, read-ahead reads 0.
> > Table 'FILE_1507'. Scan count 1, logical reads 168,
> > physical reads 0, read-ahead reads 0.
> > Table '#Imp56______________________________________________
> > ___________________________________________________________
> > _____000300026923'. Scan count 1, logical reads 1,
> > physical reads 0, read-ahead reads 0.
> > Table 'PARAMETER_LIST'. Scan count 1, logical reads 2,
> > physical reads 0, read-ahead reads 0.
> > ANI FECHA MINUTOS DNIS CONSE
> > 01-6737327869 2003-07-25 16:52:00 191845
> > 01-4777764559 2003-07-25 16:52:00 191847
> > 01-8688240799 2003-07-25 16:52:00 191848
> > 01-8183880608 2003-07-25 16:52:00 191849
> > 01-2222647171 2003-07-25 16:52:00 191850
> > 01-3747420137 2003-07-25 16:52:00 191851
> > 01-3338614151 2003-07-25 16:52:00 191853
> > 01-9535514004 2003-07-25 16:52:00 191854
> > 01-4499730935 2003-07-25 16:52:00 191855
> > 01-7221505477 2003-07-25 16:52:00 191856
> > 01-7444431362 2003-07-25 16:52:00 191857
> > 01-8183765841 2003-07-25 16:52:00 191858
> > 01-3414127311 2003-07-25 16:52:00 191859
> > 01-9383842778 2003-07-25 16:52:00 191860
> > 01-8666971263 2003-07-25 16:52:00 191861
> > 01-8717179228 2003-07-25 16:52:00 191862
> > 01-7626210374 2003-07-25 16:52:00 191863
> > 01-3338257083 2003-07-25 16:52:00 191864
> > 01-3939352246 2003-07-25 16:52:00 191865
> > 01-3336710714 2003-07-25 16:52:00 191866
> > 01-8717250405 2003-07-25 16:52:00 191867
> > 01-6969614034 2003-07-25 16:52:00 191868
> > 01-9999273910 2003-07-25 16:52:00 191869
> > 01-8332166163 2003-07-25 16:52:00 191870
> > 01-6444180747 2003-07-25 16:52:00 191871
> > 01-8181400943 2003-07-25 16:52:00 191872
> > 01-3336651373 2003-07-25 16:52:00 191873
> >
> > Table '#Imp56______________________________________________
> > ___________________________________________________________
> > _____000300026923'. Scan count 1, logical reads 1,
> > physical reads 0, read-ahead reads 0.
> >
> >
>
>


email Siga el debate Respuesta Responder a este mensaje
Ads by Google
Help Hacer una pregunta AnteriorRespuesta Tengo una respuesta
Search Busqueda sugerida