Oper
Posts: 1195
|
Posted: 03/11/2004, 11:14 AM |
|
all the Sample where done using pure ASP on IIS Server
TIme to Create 1,000 Records 11sec (INSERT)
Time to Create 50,000 Records 7min
Total Record Created 1Million records and working OK
Data Structure
ID Numeric Primary Key
CCMemo Memo File
Numero Text file
every register havea memo of long about 1kbytes (1000 letters)
the final file have around 989,456,602byte (huge)
The must Impresed part was after creating the file with 1 million records i did a small search for a none Index field
Select * from Prueba where numero = 'ABCD'"
the time ASP/MDB took to get that Record was 0.285sec
! Very impresed !
Note: i'm not inclined to any speceific Database or Langauge, people should use the one they find is easy.
but the beauty of MDB / Access is that the file are easy handled
its just 1 file.
Dont be afraid to use MDB / Access
Note: i stoped at 1million records cause i was leaving to my home!
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
Dante S.
|
Posted: 03/11/2004, 3:06 PM |
|
Oper, what version of access did you use?
"Oper" <Oper@forum.codecharge> wrote in message
news:64050ba8b423fa@news.codecharge.com...
> all the Sample where done using pure ASP on IIS Server
>
> TIme to Create 1,000 Records 11sec (INSERT)
> Time to Create 50,000 Records 7min
>
> Total Record Created 1Million records and working OK
> Data Structure
> ID Numeric Primary Key
> CCMemo Memo File
> Numero Text file
>
> every register havea memo of long about 1kbytes (1000 letters)
>
> the final file have around 989,456,602byte (huge)
>
> The must Impresed part was after creating the file with 1 million records
i did a small search for a none Index field
>
> Select * from Prueba where numero = 'ABCD'"
>
>
> the time ASP/MDB took to get that Record was 0.285sec
> ! Very impresed !
>
> Note: i'm not inclined to any speceific Database or Langauge, people
should use the one they find is easy.
>
> but the beauty of MDB / Access is that the file are easy handled
> its just 1 file.
>
> Dont be afraid to use MDB / Access
>
> Note: i stoped at 1million records cause i was leaving to my home!
>
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
Oper
Posts: 1195
|
Posted: 03/11/2004, 3:45 PM |
|
JET 4.0 ver. 4.00.6218.0
Acccess 2002 (100.2605.2625)
_________________
____________________________
http://www.7bz.com (Free CMS,CRM Developed in CCS)
http://www.PremiumWebTemplate.com
Affiliation Web Site Templates
Please do backup first |
|
|
Dammika
|
Posted: 05/10/2004, 1:52 AM |
|
Hi,
I want open a Access MDB using with PHP code which is running on
IIS server.
Best regardes
Dammika
|
|
|
|