Alfon
|
| Posted: 03/12/2004, 12:14 AM |
|
Who is faster and better?
ASP (with CC 2.0)+ Access 2000
ASP (with CC Studio 2.0)+ Access 2000
ASP (with CC 2.0)+ SQL Server
ASP (with CC 2.0 Studio)+ SQL Server
Thanks
|
|
|
 |
Oper
Posts: 1195
|
| Posted: 03/12/2004, 5:49 AM |
|
Access 2000 vs SQL
SQL server is more powerfull.
if you have a SQL server in your Develoment computer go forit
The Advantage using MDB access is that you could setup easy an IIS in any computer and just copy 1 file and you will export easy your database to any Place.
if you are not handling register over the 2GB and (100+ intranet) (200+ Internet) user at the same time, i will recomend Access.
we lot of app runing and just 2 using SQL server casue they are intranet and 100+ user, but all other are ASP/MDB and runing like Space Ship.
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
 |
|
Doru Apostolescu
|
| Posted: 03/13/2004, 4:29 AM |
|
CC 2.0 is producing ASP 2.0 code w/templates
CCStudio 2.2 is producing ASP 3.0 code w/templates
An identical application writen in both and run on the same hardware will
reveal that ASP 3.0 with templates is slightly slower than ASP 2.0 with
templates.
Also, ASP.NET is a bit slower than ASP 3.0, on the same hardware and
software (Windows Server 2003).
Access is very portable, and works very well with a small number of
simultaneous clients (queries).
- no triggers
- no stored procedures
- no timer (scheduler)
+ very cheap database
SQL Server is not very portable, but it has a very good perfomance with a
large number of clients
+ triggers
+ stored procedures
+ job scheduler
+ DTS
+ other valueable features
- the price is not small at all...
- you need clients license
--
Doru APOSTOLESCU
CNTA, CW2KA
TEHNOPLUS srl
"Alfon" <Alfon@forum.codecharge> wrote in message
news:640517183c4639@news.codecharge.com...
> Who is faster and better?
>
> ASP (with CC 2.0)+ Access 2000
>
> ASP (with CC Studio 2.0)+ Access 2000
>
> ASP (with CC 2.0)+ SQL Server
>
> ASP (with CC 2.0 Studio)+ SQL Server
>
> Thanks
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|
Alfonso
|
| Posted: 08/03/2005, 1:13 AM |
|
And it is better only ASP or ASP with template?
|
|
|
|
marcwolf
Posts: 361
|
| Posted: 08/04/2005, 4:00 PM |
|
One possibility.. and very cost effective.
MySQL..
MySQL is very powerful and has most of the common features of MSSQL at a much reduced price (free or $400 depending on licence). It runs on most platforms.
MsSQL has strange licensing where its freeish to just view the data from a web application, but you will need a $8000 (or so) Web Access license if you wish to store any information that will uniquely ID a user/browser.
There are a lot of tools around for doing the Access to MySQL transfer also.
Access starts to have issues withyou have more than 5 connections at the same time..
Very interesting stats thou on the speed of ASP3 and ASP.NET. Is this the first time the ASP.NET app is run or on subsequent runs, seeing that ASP.NET will compile the first time and then run compile the rest of the times.
Take Care
Dave
_________________
' Coding Coding Coding
Keep Those Keyboards Coding.
Raw Code!!!!!!!
|
|
|
|
Oper
Posts: 1195
|
| Posted: 08/05/2005, 11:27 PM |
|
Quote :MySQL is very powerful and has most of the common features of MSSQL at a much reduced price (free or $400 depending on licence). It runs on most platforms.
Totally Agree
Quote :Access starts to have issues withyou have more than 5 connections at the same time..
Wrong..... (its like those story people start passing from person to person and stay wrong for ever)
We have few Application runing in Not Huge Server:
CLONE 2003 1G
IDE Drive (not fast ATA) 120GB
and always 50+ terminal (intranet)
(Work really Fast) No isue "NOW"
DELL 2003 4GB
SCI 73GB
around 90ish user Alway (intratnet)
Work Fast as Hell) -- Hard Core tested.
we have some MSsql and Some MySQL we only use whne the security factor is High.
Even we have a Project were we Give Free Forum to Anyone who ask forit and there are like around 10 of those free forum that get 30ish online not problem at all (Free Forum are in a small Server Celeron 2.4 1GB, IDE drive)
We Got Few Error , Cause DeadLOCK in the MSjet Engine and Application Pool go DEAD, we fixed and we havent any isue at all after that.
Belive me MDB is very powerfull for the 80% common task. and is Free.
I like ASP.NET, loveit...... But we normaly work for WEB Server.... Dam Micrsoft get a NET Security Patch like every 2 week. so we decided use ASP ..... and only ASP.NET when Client force us.
But for Productive (use the one you know ASP,PHP,ASP.NET, MySQL,MDB,etc)
Its The Result is Good, the way sometime dont care.
http://www.Globaldevelop.com
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
navneet
|
| Posted: 08/06/2005, 12:00 PM |
|
hello oper
could you eleaborate on what you did to fix, bcz me too get this problem
We Got Few Error , Cause DeadLOCK in the MSjet Engine and Application Pool go DEAD, we fixed and we havent any isue at all after that.
|
|
|
|
donb
Posts: 52
|
| Posted: 08/06/2005, 4:21 PM |
|
Check how big your Access database gets over time. Check on whether you can backup and Access database while it's in use. Check how easy it is to manage the database remotely.
Then ask yourself if Access is a good solution for your production-quality application.
How fast it will execute a query is not everything.
_________________
http://www.gotodon.com/ccbth |
|
|
|
Oper
Posts: 1195
|
| Posted: 08/08/2005, 9:53 PM |
|
Quote :hello oper
could you eleaborate on what you did to fix, bcz me too get this problem
We Got Few Error , Cause DeadLOCK in the MSjet Engine and Application Pool go DEAD, we fixed and we havent any isue at all after that.
Windows 2003 server: has to Update SP1 + MSJet Engine Last Build
Check MSN for other OS
Quote :Check how big your Access database gets over time. Check on whether you can backup and Access database while it's in use. Check how easy it is to manage the database remotely.
Then ask yourself if Access is a good solution for your production-quality application.
How fast it will execute a query is not everything.
1) For The Call Center is HUGE (not worry about hard Diskspace)
2) And for the Backup, we dont even backup de Database we IMAGE de Server Complete without Stopping any Service, program or Users.
3) Same Software we use for maintenace MySQL,MSSQL and POSTGRESS and Access or any other Database.
Query Access Phone Database 1.5 Million records (Doing a Query searching on the name "no index" Searchin part of the name 35sec.
MySQL was 33. Cause with Index is always under 0sec.
as i said around 80% maybe more can be done wth access. (Not all)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
|
|
