| Re: sql and idl [message #41499] |
Wed, 03 November 2004 09:03  |
Michael Wallace
Messages: 409
Registered: December 2003
|
Senior Member |
|
|
You seem to be talking about apples and oranges. Access is a database
product and IDL is a data analysis product. Probably the easiest thing
to do is port the project to another database, not IDL. I'd recommend
MySQL -- stable, fast, free.
http://dev.mysql.com/tech-resources/articles/migrating-from- microsoft.html
-Mike
russ wrote:
> Hi
>
> I have acquired an MS-Access databse program from someone else which i
> need to modify/use. It has quite big files, does a few tens of sql
> queries and outputs some results. The problems are, it often crashes,
> works differently on different machines, is split up into n
> subprograms because of filesize and memoery limitations and is overall
> a bit of a mess.
>
> I was hoping to somehow rewrite in IDL. This should make it stable,
> easier to debug, on Unix etc. Afterall, it is just manipulation of
> matrices.
>
> Does anyone have any pointers or has tried this sort of thing before.
> I have been using idl for a few years and have opened an access
> database for the first time on monday. It seems to be a microsoft
> nightmare.
>
> Thanks
>
> Russ
|
|
|
|
| Re: sql and idl [message #41634 is a reply to message #41499] |
Thu, 04 November 2004 04:53  |
rlayberry
Messages: 33
Registered: November 2004
|
Member |
|
|
Yep, I know what you mean, but I think the thing should have been
originally written in IDL. It is just applying algorithms to
matrices. It was written by a guy who had no programming experience
and so he used access. It has grown to become ridiculously unwieldy,
whereas the algorithms are not that complex (but difficult to reverse
engineer from looking at the database/tables and queries).
russ
> You seem to be talking about apples and oranges. Access is a database
> product and IDL is a data analysis product. Probably the easiest thing
> to do is port the project to another database, not IDL. I'd recommend
> MySQL -- stable, fast, free.
>
> http://dev.mysql.com/tech-resources/articles/migrating-from- microsoft.html
>
> -Mike
>
>
> russ wrote:
>> Hi
>>
>> I have acquired an MS-Access databse program from someone else which i
>> need to modify/use. It has quite big files, does a few tens of sql
>> queries and outputs some results. The problems are, it often crashes,
>> works differently on different machines, is split up into n
>> subprograms because of filesize and memoery limitations and is overall
>> a bit of a mess.
>>
>> I was hoping to somehow rewrite in IDL. This should make it stable,
>> easier to debug, on Unix etc. Afterall, it is just manipulation of
>> matrices.
>>
>> Does anyone have any pointers or has tried this sort of thing before.
>> I have been using idl for a few years and have opened an access
>> database for the first time on monday. It seems to be a microsoft
>> nightmare.
>>
>> Thanks
>>
>> Russ
|
|
|
|
comp.lang.idl-pvwave archive
Members
Search
Help
Login
Home
