Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mapperkids
Yak Posting Veteran
50 Posts |
 Posted - 2006-06-24 : 09:12:28
|
| Hi,We are plan to develop a new VB6 / MS Access application that will produce a whole bundle of reports for the outside salesman team (all of them have a laptop). The data is come from midrange AS400 tables.Now we have decided should we using SQL Express with SQL tables or just MS Access MDB tables. Some of the laptop the salesman is only P3-800 and I'm worry about the speed for SQL express on those laptop.The other hand, I like to use SQL databases, since we have the SQL server 2005 running for other application already.Any one tested the performance between the SQL Express via MS MDB, it seems the SQL 2005 express is use more overhead than MSDE.We tried the MSDE and the performance is not that great after the database grow beyond 500MB .Any suggestion are welcome.Thnaks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-24 : 11:30:09
|
| WHy not put in a database access layer which will allow you to swap between databases so you don't have to make the decision but can support both.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
mapperkids
Yak Posting Veteran
50 Posts |
Posted - 2006-06-24 : 21:36:00
|
| what it means by database layer and support both?Thanks! |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2006-06-27 : 11:12:37
|
| "....We tried the MSDE and the performance is not that great after the database grow beyond 500MB ."You should be even more worried by MSDE's overall limit of the database that must be less than <2GB. No point in worrying about a slow database, when adding more data will stop it running altogether! |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-27 : 13:15:44
|
quote:
Originally posted by mapperkids
what it means by database layer and support both?Thanks!
Have a look at http://www.nigelrivett.net/VB/VB6DataAccessLayer.htmlYou could implement something like that and use it to alter the code depending on the connection type. In that way you can connect to sql server or access with the same application.I would be concerned about the size of the database in access as well if you have > 500MB at the moment.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
need some suggestion?