Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like 'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that many
big sites have access database. Is it ok, ir it is big risk?
17  1414 
Igor wrote:
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like 'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that many
big sites have access database. Is it ok, ir it is big risk?
Assuming that:
- you have index on Name column
- the MDB is on a local disk
- the disk is not heavily used by something else
- the unique visitors only make one query (or only a few)
- the load is reasonable good distributed over time
then it should not be a problem.
30 MB can easily be cached in disk/file cache.
10000/day is only 7/minute over 24 hours or 21/minute over
8 hours and that is not heavy.
Arne
You might want to cache items that are very often run (but seldom change)
queries.
There is a Cache object in the System.Web namespace.
You can also find an object called "WeakReference" which is a way to cache
items, but to release them if there is a memory drain.
I wouldn't start with Access. I'd start with MSDE (2000) or Sql Express
(2005).
But you might be able to pull it off.
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
'SomeName%').
>
Can it be problem if I have 10 000 unique visitors per day? I see that
many
big sites have access database. Is it ok, ir it is big risk?
Igor,
It is the same as the others wrote, however probably easier to manage.
You can set a dataset shared in your program. Because all your users share
the same application is that for all your users. It has to be a dataset that
from the userside will never be changed otherwise you should never create a
shared dataset in an AspNet appliction.
Don't forget to make an extra page to set the dataset to nothing, otherwise
you can never change it.
Cor
"Igor" <ig**@nesalji.hrschreef in bericht
news:em**********@sunce.iskon.hr...
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that
many big sites have access database. Is it ok, ir it is big risk?
use SQL Express, it is free and durable
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that
many big sites have access database. Is it ok, ir it is big risk?
use SQL Express, it is free and durable
Hi Igor,
Are you from the Netherlands?
Cor
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
>Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that
many big sites have access database. Is it ok, ir it is big risk?
Hi Igor,
>
Are you from the Netherlands?
No, I am from Croatia!
Assuming that:
- you have index on Name column
What index?
- the MDB is on a local disk
It is on web hosting account like www.webhost4life.com. It is on fast server
(i hope that it is true).
- the disk is not heavily used by something else
It is shared hosting, but good hosting.
- the unique visitors only make one query (or only a few)
One or few queries in one page load.
- the load is reasonable good distributed over time
Distribution... hmm. It is for tourist agency. Visitors mostly come at
summer. I don't know how many often at different hours.
30 MB can easily be cached in disk/file cache.
Can I cashe this if it is not on my server. It is on shared hosting named
webhost4life.com or something simmilar (profesional hosting).
10000/day is only 7/minute over 24 hours or 21/minute over
8 hours and that is not heavy.
What if 100 or 300 visitors come at the same second and every of them
request 2-3 select queries?
I thought that you was Dutch, because there was asked about speed and you
are answering about the cost.
:-)
Cor
"Igor" <ig**@nesalji.hrschreef in bericht
news:em**********@sunce.iskon.hr...
>Hi Igor,
Are you from the Netherlands?
No, I am from Croatia!
1. Go into Table view of the MDB containing the actual data.
2. Open the table in design mode.
3. Go to the bottom of the screen under the 'General' tab.
4. Find the Indexed property and set it to 'Yes" either with or without
duplicates, depending on your data.
(this may vary a little bit depending on your version of Access)
Brooks
Igor wrote:
Assuming that:
- you have index on Name column
What index?
4. Find the Indexed property and set it to 'Yes" either with or without
duplicates, depending on your data.
(this may vary a little bit depending on your version of Access)
Why indexed filed is important, because of speed or something else?
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
>4. Find the Indexed property and set it to 'Yes" either with or without
duplicates, depending on your data.
(this may vary a little bit depending on your version of Access)
Why indexed filed is important, because of speed or something else?
You *really* need to find a beginner's guide to databases... Indexes are
absolutely fundamental to database performance.
As others have pointed out, Access is not particularly suited to web
deployment but, if you're determined to use it, this might be a good place
to start: http://www.amazon.com/Access-2003-Al...e=UTF8&s=books
Yes, primarly for speed.
Mark is right, get Access for Dummies.
It is scary that you are trying to do this without more knowledge of
databases and Access. You are probably going to have further issues
....
A STRONG Access developer may be able to make this work and will know
when it is time to move to SQL Server. A newbie ...
Brooks
Why indexed filed is important, because of speed or something else?
"brooksr" <br****@rimesrv.netwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
A STRONG Access developer may be able to make this work and will know
when it is time to move to SQL Server. A newbie ...
No chance whatsoever...
"Mark Rae" <ma**@markNOSPAMrae.comwrote in message
news:uK**************@TK2MSFTNGP03.phx.gbl...
"brooksr" <br****@rimesrv.netwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
>A STRONG Access developer may be able to make this work and will know
when it is time to move to SQL Server. A newbie ...
No chance whatsoever...
That's not true. Sometimes people have dumb luck. ;-)
Robin S.
SQL Express is not well suited to shared hosting environments, especially
if your provider is using IIS 6.0 or above and has assigned every site it's
own application pool, which is the most common scenario.
SQL Express is good, however it is a bit of a memory hog, it uses a fair
chunk of memory, at least 80-100Megs. If the server is hosting hundreds of
sites using SQL Express you can see how this might become a problem pretty
quickly.
Alternatively if your application is in a shared pool then SQL Express is
probably OK; however you will have all the security and reliability
problems that come with that sort of environment.
If you really believe your site is going to get that much traffic, make your
life easy, just develop for SQL Server.
If you use Access you're probably going to have to get into some threading
stufff, code a DAL with a mutex to stop multiple threads simultaneously
trying to write to your Access file, reads could be less of a problem but I
wouldn't bet my life on it's reliability.
In any case with Access, response times are going to be an issue under load,
and in many cases it's going to crash and require continuous
recycling/rebooting of your server or application pool (depending on the
setup).
Michael www.mblmsoftware.com
"Rotsey" <ma***********@RemoveThis.optusnet.com.auwrote in message
news:u8**************@TK2MSFTNGP02.phx.gbl...
use SQL Express, it is free and durable
"Igor" <ig**@nesalji.hrwrote in message
news:em**********@sunce.iskon.hr...
>Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where Name like
'SomeName%').
Can it be problem if I have 10 000 unique visitors per day? I see that
many big sites have access database. Is it ok, ir it is big risk?
"Michael Lang" <micklang at gmail.comwrote in message
news:ON**************@TK2MSFTNGP02.phx.gbl...
SQL Express is not well suited to shared hosting environments, especially
if your provider is using IIS 6.0 or above and has assigned every site
it's own application pool, which is the most common scenario.
1. I have hosting with SQL Server Express and I have SQL Server 2000
developer edition on my computer. I will get SQL Server 2005 soon. What is
the best solution?
2. I am thinking about MySQL Database with ASP.NET 2.0 (C# 2005) for this
aplication. What do you think about this combination?
Access MDB is a decent database.
But I sure as fuck wouldn't use Access forms and DAO against MDB.
that's just plain unreliable.
MDB is a pain in the ass..
Using SQL Server would probably be easier.
-Aaron
Mark Rae wrote:
"brooksr" <br****@rimesrv.netwrote in message
news:11**********************@f1g2000cwa.googlegro ups.com...
A STRONG Access developer may be able to make this work and will know
when it is time to move to SQL Server. A newbie ...
No chance whatsoever...
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Web Science |
last post by:
Site and Features: http://www.eigensearch.com
Search engine, eigenMethod, eigenvector, mathematical, manifolds, science, technical, search tools, eigenmath, Jacobian, quantum, mechanics,...
|
by: Laphan |
last post by:
Hi All
I know this is my 2nd (and final) cross-post, but which NG should I use for
the below.
I want to create a game that queries and updates text and numeric stats on a
regular basis, so...
|
by: matt |
last post by:
Hi all-
I'm trying to port an ajax spell-checker
(http://www.broken-notebook.com/spell_checker/index.php) to use with
the moin moin wiki and have been somewhat successful. (By successful I...
|
by: Web Science |
last post by:
Site and Features: http://www.eigensearch.com
Search engine, eigenMethod, eigenvector, mathematical, manifolds, science, technical, search tools, eigenmath, Jacobian, quantum, mechanics,...
|
by: Web Science |
last post by:
Site and Features: http://www.eigensearch.com
Search engine, eigenMethod, eigenvector, mathematical, manifolds, science, technical, search tools, eigenmath, Jacobian, quantum, mechanics,...
|
by: venkatbo |
last post by:
Hi all,
We've managed to cross-compile (from i686 targeting ppc) python (2.4.2)
binaries and
extension modules.
However we cannot figure out how to cross-compile the .py (of
distribution)...
|
by: Igor |
last post by:
Can I use access for big database (cca 10-30 MB, cca 10-30k lines in
database). It will be asp.net 2.0 aplication and very fast server. Mostly
simple transactions (like SELECT * From Books Where...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 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 former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |
