2005 Express Edition Capacity

I am looking for an inexpensive (less than $200 in quantity 100 per month)
database that will meet the following requirements:
Max database file size 2 Gb
Max number of records 2 million
Record insertion rate: 10 per second
Queries while inserting: Max time to complete a basic query over the 2
million records: 5 sec
The database must be robust, i.e. no lost data when inserting and querying.
Does it seem that Express Edition of SQL 2005 would meet these requirements,
especially the number of records and timing requirements? The application is
limited to one computer.
"Rahim" <Rahim@.discussions.microsoft.com> wrote in message
news:5C2C04DA-2CF3-4F85-983A-80F42ABD2CC1@.microsoft.com...
>I am looking for an inexpensive (less than $200 in quantity 100 per month)
> database that will meet the following requirements:
> Max database file size 2 Gb
> Max number of records 2 million
> Record insertion rate: 10 per second
> Queries while inserting: Max time to complete a basic query over the 2
> million records: 5 sec
> The database must be robust, i.e. no lost data when inserting and
> querying.
> Does it seem that Express Edition of SQL 2005 would meet these
> requirements,
> especially the number of records and timing requirements? The application
> is
> limited to one computer.
|||SQLExpress will have no problems with those rates give a proper design and
appropriate hardware. 2 million rows is pretty small for a SQL DB these
days and as long as you have a proper index and are not returning enough
rows to force a scan that should no be a problem. It is free but you should
look at the licensing to make sure you fit the requirements.
Andrew J. Kelly SQL MVP
"Rahim" <Rahim@.discussions.microsoft.com> wrote in message
news:5C2C04DA-2CF3-4F85-983A-80F42ABD2CC1@.microsoft.com...
>I am looking for an inexpensive (less than $200 in quantity 100 per month)
> database that will meet the following requirements:
> Max database file size 2 Gb
> Max number of records 2 million
> Record insertion rate: 10 per second
> Queries while inserting: Max time to complete a basic query over the 2
> million records: 5 sec
> The database must be robust, i.e. no lost data when inserting and
> querying.
> Does it seem that Express Edition of SQL 2005 would meet these
> requirements,
> especially the number of records and timing requirements? The application
> is
> limited to one computer.
|||"Rahim" <Rahim@.discussions.microsoft.com> wrote in message
news:5C2C04DA-2CF3-4F85-983A-80F42ABD2CC1@.microsoft.com...
>I am looking for an inexpensive (less than $200 in quantity 100 per month)
> database that will meet the following requirements:
> Max database file size 2 Gb
> Max number of records 2 million
> Record insertion rate: 10 per second
> Queries while inserting: Max time to complete a basic query over the 2
> million records: 5 sec
> The database must be robust, i.e. no lost data when inserting and
> querying.
> Does it seem that Express Edition of SQL 2005 would meet these
> requirements,
> especially the number of records and timing requirements? The application
> is
> limited to one computer.
The capacities you mentioned aren't a problem. The only question is over the
rate of updates and the time to complete your queries. These will be
determined by your processor, storage and network performance rather than by
the database software.
10 rows per second looks a little bit odd next to your 2 million row metric.
If 10 rows per second is an average then apparently your database only
retains about 55 hours worth of data.
In the case of your query performance, that's obviously entirely dependent
on the nature of the query. You'll have to test it out.
Hope this helps.
David Portas
SQL Server MVP
|||"Andrew J. Kelly" wrote:

> SQLExpress will have no problems with those rates give a proper design and
> appropriate hardware. 2 million rows is pretty small for a SQL DB these
> days and as long as you have a proper index and are not returning enough
> rows to force a scan that should no be a problem. It is free but you should
> look at the licensing to make sure you fit the requirements.
> --
> Andrew J. Kelly SQL MVP
>
> "Rahim" <Rahim@.discussions.microsoft.com> wrote in message
> news:5C2C04DA-2CF3-4F85-983A-80F42ABD2CC1@.microsoft.com...
>
> Thank you very much for your reply.
|||"David Portas" wrote:

> "Rahim" <Rahim@.discussions.microsoft.com> wrote in message
> news:5C2C04DA-2CF3-4F85-983A-80F42ABD2CC1@.microsoft.com...
> The capacities you mentioned aren't a problem. The only question is over the
> rate of updates and the time to complete your queries. These will be
> determined by your processor, storage and network performance rather than by
> the database software.
> 10 rows per second looks a little bit odd next to your 2 million row metric.
> If 10 rows per second is an average then apparently your database only
> retains about 55 hours worth of data.
> In the case of your query performance, that's obviously entirely dependent
> on the nature of the query. You'll have to test it out.
> Hope this helps.
> --
> David Portas
> SQL Server MVP
> --
>
> Thank you for your reply.
The Database will serve to temporarily retain detailed production
information until the product is shipped, after which the information is
discarded, or in a future incarnation, archived. Thus the apparent 55 hour
capacity.