jwcolby
jwcolby at colbyconsulting.com
Thu Jul 8 12:39:41 CDT 2010
Yes it can be, though I run it wired unless I am using the laptop downstairs. However I was running the SQL Server instance directly on the laptop. I gave it 500 megs of ram for itself and limited it to a single CPU. The database is tiny, the actual file size is under 12 megs. I even gave SQL Server its own partition- about 2 gigs - on the one and only drive in the laptop - this in an effort to prevent fragmentation etc. Now that I am running the Access FE off of a SQL database on my main SQL Server machine the database is instantaneous. John W. Colby www.ColbyConsulting.com Michael Bahr wrote: > John, is your laptop wireless? > > Mike... > >> I have reported problems with very slow performance of my billing SQL >> Server database. The database >> was running on my laptop and the performance was abysmal. Well today I >> decided to move it to my SQL >> Server machine and holy smoke batman, it is blazing fast. >> >> So whatever the problem, it is related to the SQL Server instance on my >> laptop. >> >> Now to troubleshoot how to make it faster there. I have some natural >> limitations of course since I >> only have two cores and 3.25 gigs of RAM TOTAL for the laptop. I didn't >> really expect that to be an >> issue since the database itself is only a few megs. >> >> What would be really nice would be to somehow run off of the server when I >> am at home (99% of the >> time) but keep the laptop synced to the server so that I could switch to >> the local copy when I am on >> the road. At that point I would probably just put up with the slowness, >> although now that I know >> that the slowness is in my local instance I will definitely troubleshoot >> further. >> >> On that note however... >> >> I have a view that I used to allow me to enter my time records. On my >> local machine it allows me to >> add records. On the remote server it does not. All of my tables do allow >> me to enter data if >> opened directly (in Access in the table window). >> >> That problem aside, I shall definitely enjoy my new found speed. >> >> -- >> John W. Colby >> www.ColbyConsulting.com >> -- >> AccessD mailing list >> AccessD at databaseadvisors.com >> http://databaseadvisors.com/mailman/listinfo/accessd >> Website: http://www.databaseadvisors.com >> > >