I have a VB.NET web application using SQL Server. I need to do weekly and
monthly processing on that database that will probably require a couple
hours to complete, so having this run in the web application is probably not
a good idea.
I'd like to keep this all in the VS.NET environment (VB.NET). Should I be
using a Windows Service, or a Windows Application?
It will be able to run off a config file, changed by a web site admin
interface.
-Max 4 1368
"msnews.microso ft.com" <ma*****@portvi sta.com> wrote in message
news:uG******** ******@TK2MSFTN GP09.phx.gbl... I have a VB.NET web application using SQL Server. I need to do weekly and monthly processing on that database that will probably require a couple hours to complete, so having this run in the web application is probably
not a good idea.
I'd like to keep this all in the VS.NET environment (VB.NET). Should I be using a Windows Service, or a Windows Application?
It will be able to run off a config file, changed by a web site admin interface.
It doesn't really matter how you do this. It depends on your environment and
your comfort levels.
VS.NET makes it easy to create a Windows Service, so you could do it that
way. You could also create a console application and run it as a scheduled
task. I've done both, and they both work well.
--
John Saunders
johnwsaundersii i at hotmail
Why don't you just create a DTS package to do this? I know you want to keep
it in VS.NET environment, but there are a lot of advantages to just using
DTS.
-John Oakes
"msnews.microso ft.com" <ma*****@portvi sta.com> wrote in message
news:uG******** ******@TK2MSFTN GP09.phx.gbl... I have a VB.NET web application using SQL Server. I need to do weekly and monthly processing on that database that will probably require a couple hours to complete, so having this run in the web application is probably
not a good idea.
I'd like to keep this all in the VS.NET environment (VB.NET). Should I be using a Windows Service, or a Windows Application?
It will be able to run off a config file, changed by a web site admin interface.
-Max
Yes I've thought of that, but I'm simply not good at TSQL. I'll most
definately be using stored procedures to break the process down in chunks,
and have some reuse available to me, but there is a lot of intense
calculations with the results (100,000's of records) being stored in several
tables, probably not even a temp tables, because this data needs to be
highly available after the process is done.
Hopefully I'll be able to keep the calls to the database low, as well as the
amount of data being transfered between SQL Server and the Windows service.
Eventually I want this to be running on its own dedicated server perhaps.
Some processes may run on the hour.
I guess I'm asking here to make sure I'm considering all the options.
-Max
"John Oakes" <jo**@nospam.ne tworkproduction s.net> wrote in message
news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Why don't you just create a DTS package to do this? I know you want to
keep it in VS.NET environment, but there are a lot of advantages to just using DTS.
-John Oakes
What kind of calculations? You would probably be better off doing them all
in TSQL. If you use DTS, a lot of the functionality you need is already
there. You won't have to write code to run on a schedule, notify you of
results, etc. If you put all of your SQL code in stored procedure you can
just call those from the DTS package.
-John Oakes
"Max" <ma*****@portvi sta.com> wrote in message
news:mZ******** ***********@twi ster.tampabay.r r.com... Yes I've thought of that, but I'm simply not good at TSQL. I'll most definately be using stored procedures to break the process down in chunks, and have some reuse available to me, but there is a lot of intense calculations with the results (100,000's of records) being stored in
several tables, probably not even a temp tables, because this data needs to be highly available after the process is done.
Hopefully I'll be able to keep the calls to the database low, as well as
the amount of data being transfered between SQL Server and the Windows
service. Eventually I want this to be running on its own dedicated server perhaps. Some processes may run on the hour.
I guess I'm asking here to make sure I'm considering all the options.
-Max
"John Oakes" <jo**@nospam.ne tworkproduction s.net> wrote in message news:%2******** ********@TK2MSF TNGP10.phx.gbl. .. Why don't you just create a DTS package to do this? I know you want to keep it in VS.NET environment, but there are a lot of advantages to just
using DTS.
-John Oakes
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: msnews |
last post by:
Hi All,
We have a requirement to display total number of current users using the
site. We want to display only the total no other information. And this value
needs to change dynamically.
Is it possible to do this? Please let me know how to do it.
Thanks.
|
by: MLH |
last post by:
A97 procedure to open http://www.arch.com/message/
enter an 800 number, press "Continue", enter a text msg
string from a memo field and press "Send"
This is a calendaring and appointment A97 database for
an attorney's office. I'm sure it must be do-able. I know
better than to mention the term "S__dK__ys" in conjunction
with this topic. I've read enough in here to know that is
extremely unreliable. Am sorry even that I have to use
IE...
|
by: Wayne P. |
last post by:
I'm working on a shopping cart webapp and I need to perform a form POST of
data to a 3rd party site (a payment processor, StormPay).
I seem to be having problems doing this. I have an image button which when
clicked performs the data validation. After successful validation, I need
the browser to redirect to the payment processer with a form post. How can
I do this?
I have tried a few things, failed. Below were my most 'reasonable...
|
by: gabedog |
last post by:
What would be a good (and safe) way to enable/disable a web site in a
web farm that needs to come down for maintenance?
Periodically, we have db folks that run db scripts. I'd like to put a
back door page with a login that would allow me to remotely enable and
disable the site. The site is in a web farm. The site has a previously
posted message to users when the site will go down. How can this be
done safely and efficiently in a web farm...
|
by: onceuponapriori |
last post by:
Greetings gents. I'm a Railser working on a django app that needs to do
some scraping to gather its data.
I need to programatically access a site that requires a username and
password. Once I post to the login.php page, there seems to be a
redirect and it seems that the site is using a session (perhaps a
cookie) to determine whether the user is logged in. So I need to log in
and then have cookies and or sessions maintained as I access...
| |
by: Murray R. Van Luyn |
last post by:
Hi,
Since I have made changes to my website it's been a complete flop. According
to the logs, as soon as visitors have downloaded the index page they are
off. I can't figure out why?
http://www.review-a-gadget.com/
Is there anything obvious that I am missing? Are there problems with some
browsers? Please let me know if you notice anything.
|
by: Jim Hill |
last post by:
Well, I've found about a hundred thousand web pages where people have
had the same problem I have but nary a page with a solution that works
for me.
I want to do a simple embed, so I've followed the example in the
Extending and Embedding documentation:
In the .c file,
#include <Python.h>
|
by: Ben Sehara |
last post by:
Is there any way I can limit the access to my website? I have a site "A" and
I want to allow access to it only from site "B" login user.
If someone try to access site "A" directory, I want it redirected to site
"B" for login. After login at site "B", you see the link to site"A". When
you click it, you see login page for site "A".
Is it possible?
Thanks.
|
by: ccrocetti |
last post by:
Hello,
I am having some trouble with performance issues using ASP.NET.
We have a single code-base that is used as a wrapper for multiple sites. The data for the site is populated from the database, and based on the URL of the site, displays different content. Currently there are 30 different sites in IIS, all in the same Application Pool, and all pointing at the same code-base.
The performance issue is, when we have to make an...
|
by: samatair |
last post by:
Hi All,
My client needs Pay Pal payments to be made within the site. i.e the user should not be send to the Pay Pal site and return back to the client's site. The payment should be done within the client site itself.
I don't have any previous exposure with this.
If anyone has implemented this kind of thing can you please help me with this.
I want to know
What are the requirements to implement this?
Can I implement this using only PHP?...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| | |