I am running a database with medical claims data on a laptop using a single-user version of SQL (Express 2005). There are actually 6 databases with 3,000,000 records in each database. I do a lot of work remotely on audits and this appears to be best solution for variety of reasons. All data is encrypted using PGP. Performance is OK but I need to replace the laptop.
What are some considerations in the laptop – 64-bit OS – how much memory and how much will processor speed impact performance? The data is stored on solid-state drive. I guess I am really asking at what point will I begin to waste money on more memory - faster processor.
Is there any easy way to port the sql application from one laptop to another?