November 18th, 2003, 08:06 PM
|
|
Contributing User
|
|
Join Date: Sep 2003
Posts: 67
Time spent in forums: 1 h 57 m 17 sec
Reputation Power: 5
|
|
|
Which way run FASTER?
Catergory : Apple, Banana, Orange, Papaya
Lines of Records : Apple - 95k, Banana - 50k, Orange - 15k, Papaya - 175k
(5 field each)
Scenario A
Create Each table for each category - Apple, Banana, Orange, Papaya in single database file
Scenario B
Create Each table for each category for each database file.
(i.e. apple.mdb, banana.mdb, orange.mdb, papaya.mdb)
The above scenario will be on MS Access environment.
Which provide faster read, write (select, update) speed? or any other more efficient way?
Last edited by alam : November 19th, 2003 at 04:45 AM.
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
