Ok,
I have written our invoice printing software using the rs.render on
Bryan Keller' blog (of Microsoft) to directly send the Invoice with RS
straight to the printer as an EMF. It is painfully slow, but I found
that the speed almost tripples using my development computer which uses
dual Xeon Intel processing. Unfortunately, I don't want to give up my
development machine for the shipping department.
I guess, when rendering graphics (which in this mannor is an Image
file), there is no workaround without the proper hardware. You will
need faster Image rendering processor.
The company isn't using my application yet because they may want me to
re-write it without Reporting Services because of this problem. So,
they continue to use the old asp app someone wrote a couple of years
ago which sends to dot-matrix printers (instead of my fancy, but slow
way to the NICE laser jets).
If anyone knows something I don't, after unbelieveable research and
problems with this, PLEASE let me in on your secret.
Thanks,
TrintThe difference in speed might be RAM, not processor. Is there a big
difference in RAM between the two machines? If so, upgrading RAM is a lot
cheaper than creating a new solution (or buying a new machine).
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"trint" <trinity.smith@.gmail.com> wrote in message
news:1123497399.592828.55160@.o13g2000cwo.googlegroups.com...
> Ok,
> I have written our invoice printing software using the rs.render on
> Bryan Keller' blog (of Microsoft) to directly send the Invoice with RS
> straight to the printer as an EMF. It is painfully slow, but I found
> that the speed almost tripples using my development computer which uses
> dual Xeon Intel processing. Unfortunately, I don't want to give up my
> development machine for the shipping department.
> I guess, when rendering graphics (which in this mannor is an Image
> file), there is no workaround without the proper hardware. You will
> need faster Image rendering processor.
> The company isn't using my application yet because they may want me to
> re-write it without Reporting Services because of this problem. So,
> they continue to use the old asp app someone wrote a couple of years
> ago which sends to dot-matrix printers (instead of my fancy, but slow
> way to the NICE laser jets).
> If anyone knows something I don't, after unbelieveable research and
> problems with this, PLEASE let me in on your secret.
> Thanks,
> Trint
>
Showing posts with label written. Show all posts
Showing posts with label written. Show all posts
Monday, March 12, 2012
Friday, February 24, 2012
How to get last record ?
Dear all,
I am writing a store procedure which should return the last entry whcih has
been written in a database table.
That store procedure will always return the last recorded entry from a table
How to do that ?
regards
sergeHi Serge,
What is the "last" record in your case ?
SQL Server doesn=B4t care about the order of data unless you specify an
Order in a Select query or you can determine the last entry via an
identity column or a column which store the modified date.
HTH, Jens Suessmeyer.|||You need to add datetime column and insert the value when you add a record.
Then you can select the most recent record in the table.
something like
select top 1 <column list>
from table
order by Time_inserted DESC
Thats offcourse if you mean 'last' by time of insert. If you want to handle
updates ('LastChanged') read about timestamp in the BOL.
MC
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:EB64CB5C-40D0-42E2-A56B-31205AB24C7D@.microsoft.com...
> Dear all,
> I am writing a store procedure which should return the last entry whcih
> has
> been written in a database table.
> That store procedure will always return the last recorded entry from a
> table
> How to do that ?
> regards
> serge|||If you don't record the information about which row was the last then
SQL Server won't do it for you. The answer is something like:
SELECT ,,,
FROM your_table
WHERE created_date =
(SELECT MAX(created_date)
FROM your_table) ;
David Portas
SQL Server MVP
--|||Hi Jens,
nased on that, I have a column in my database table Identified as START_TIME
which is of type DataTime.
Based on that column, the "last" record will be the one who have the biggest
DateTIme value.
any tip ?
"Jens" wrote:
> Hi Serge,
> What is the "last" record in your case ?
> SQL Server doesn′t care about the order of data unless you specify an
> Order in a Select query or you can determine the last entry via an
> identity column or a column which store the modified date.
> HTH, Jens Suessmeyer.
>|||Thnaks it works
"MC" wrote:
> You need to add datetime column and insert the value when you add a record
.
> Then you can select the most recent record in the table.
> something like
> select top 1 <column list>
> from table
> order by Time_inserted DESC
> Thats offcourse if you mean 'last' by time of insert. If you want to handl
e
> updates ('LastChanged') read about timestamp in the BOL.
> MC
>
> "serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
> message news:EB64CB5C-40D0-42E2-A56B-31205AB24C7D@.microsoft.com...
>
>
I am writing a store procedure which should return the last entry whcih has
been written in a database table.
That store procedure will always return the last recorded entry from a table
How to do that ?
regards
sergeHi Serge,
What is the "last" record in your case ?
SQL Server doesn=B4t care about the order of data unless you specify an
Order in a Select query or you can determine the last entry via an
identity column or a column which store the modified date.
HTH, Jens Suessmeyer.|||You need to add datetime column and insert the value when you add a record.
Then you can select the most recent record in the table.
something like
select top 1 <column list>
from table
order by Time_inserted DESC
Thats offcourse if you mean 'last' by time of insert. If you want to handle
updates ('LastChanged') read about timestamp in the BOL.
MC
"serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
message news:EB64CB5C-40D0-42E2-A56B-31205AB24C7D@.microsoft.com...
> Dear all,
> I am writing a store procedure which should return the last entry whcih
> has
> been written in a database table.
> That store procedure will always return the last recorded entry from a
> table
> How to do that ?
> regards
> serge|||If you don't record the information about which row was the last then
SQL Server won't do it for you. The answer is something like:
SELECT ,,,
FROM your_table
WHERE created_date =
(SELECT MAX(created_date)
FROM your_table) ;
David Portas
SQL Server MVP
--|||Hi Jens,
nased on that, I have a column in my database table Identified as START_TIME
which is of type DataTime.
Based on that column, the "last" record will be the one who have the biggest
DateTIme value.
any tip ?
"Jens" wrote:
> Hi Serge,
> What is the "last" record in your case ?
> SQL Server doesn′t care about the order of data unless you specify an
> Order in a Select query or you can determine the last entry via an
> identity column or a column which store the modified date.
> HTH, Jens Suessmeyer.
>|||Thnaks it works
"MC" wrote:
> You need to add datetime column and insert the value when you add a record
.
> Then you can select the most recent record in the table.
> something like
> select top 1 <column list>
> from table
> order by Time_inserted DESC
> Thats offcourse if you mean 'last' by time of insert. If you want to handl
e
> updates ('LastChanged') read about timestamp in the BOL.
> MC
>
> "serge calderara" <sergecalderara@.discussions.microsoft.com> wrote in
> message news:EB64CB5C-40D0-42E2-A56B-31205AB24C7D@.microsoft.com...
>
>
Subscribe to:
Posts (Atom)