General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
MSDE has a 2 gig limit per database. Multiple databases are permitted. However, there is a user connection limit, after which speed is throttled to match the Jet engine. ...and MSDE is a hassle to move from computer to computer.
You may want to investigate MSDE 2005 (SQL Express). The beta is released. It promises portability, 2 gig limitation removed, and no throttling of performance.
All things considered, I would split the tables horizontally or vertically. You will get better performance as a side benefit.
- Don Lowrey
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only