Hello-
It's been a long time since I have been on the board. I have completely
retired, except for maintaining our medical billing system - which brings
me to the question.
Some time ago, because of my precarious health, my wife convinced me
that we needed to purchase a billing program from someone else. Ok, I said. So we did. BUMMER !!
After we got it, discovered that it was using (shudder) an ACCESS database.
We have developed a subset of our own billing system for the doctors office's
for inquiry purposes only.
I have had no previous experience with SQL or ADO. I read enough to try AlphaADO
to create passive files in Alpha, from the ACESS .mdb files. I used our smalles
doctor files as a test. Worked great, except it took a terribly long time, over 2hours. At that rate, our largest doctor would take overnight.
This was done on my DELL E527 with 2gb of memory, which has seemed to me to be
pretty fast.
I then duplicated what I had done on a 2nd machine, an older Dell 2350, with only
512mb of memory. It ran the same file in a little over 2 minutes.
I have checked every thing I can think of, reinstalled V9, upgraded to SQL server 2008, and I have had no speed up at all. If anyone can think of anything I should
look for, I would appreciate it.
Thanks,
Lowell
It's been a long time since I have been on the board. I have completely
retired, except for maintaining our medical billing system - which brings
me to the question.
Some time ago, because of my precarious health, my wife convinced me
that we needed to purchase a billing program from someone else. Ok, I said. So we did. BUMMER !!
After we got it, discovered that it was using (shudder) an ACCESS database.
We have developed a subset of our own billing system for the doctors office's
for inquiry purposes only.
I have had no previous experience with SQL or ADO. I read enough to try AlphaADO
to create passive files in Alpha, from the ACESS .mdb files. I used our smalles
doctor files as a test. Worked great, except it took a terribly long time, over 2hours. At that rate, our largest doctor would take overnight.
This was done on my DELL E527 with 2gb of memory, which has seemed to me to be
pretty fast.
I then duplicated what I had done on a 2nd machine, an older Dell 2350, with only
512mb of memory. It ran the same file in a little over 2 minutes.
I have checked every thing I can think of, reinstalled V9, upgraded to SQL server 2008, and I have had no speed up at all. If anyone can think of anything I should
look for, I would appreciate it.
Thanks,
Lowell
Comment