Moving to SQL?
in [Visual Objects]
|
Prev: MLE Cursor Position
Next: Source control problem
From: Henry on 2 Jul 2008 06:38 Until now I am using dBase databases, the server is marked as disk "M: \", the default directorey is "M:\...", so every opening of a database is performed automatically on the server. There are only 7 computers on the net. In order to speed performance, I am considering passing to SQL. How can I do it with minimum edit of the existing code? Can I await a considerable change in performance? Many thanks for any hint Henry.
From: Geoff Schaller on 2 Jul 2008 07:32 Henry. You need a class based approach, such as that which I am doing now with about 12 companies around the globe. Check out my website for white papers (it is slow at the moment so please be patient - our fault) at www.sofwareobjectives.com.au/voconversion There is a lot of reading there. Basically, we can convert a DBF oriented app to SQL in a few weeks (say 250,000 lines of code, 150 tables and 50 browsers) and your code will largely stay in DBF syntax. This can work for MS SQL, DB2 or Oracle. Or you can write lots of SQL and take forever <g>. Geoff "Henry" <ZodcomAG(a)yahoo.com> wrote in message news:cb073750-0080-4c2c-940f-ee82475c3006(a)e53g2000hsa.googlegroups.com: > Until now I am using dBase databases, the server is marked as disk "M: > \", the default directorey is "M:\...", so every opening of a database > is performed automatically on the server. > There are only 7 computers on the net. > > In order to speed performance, I am considering passing to SQL. > How can I do it with minimum edit of the existing code? > Can I await a considerable change in performance? > > Many thanks for any hint > Henry.
From: Geoff Schaller on 2 Jul 2008 08:03 Oops. The correct URL is: http://www.softwareobjectives.com.au/voconversion Geoff
From: Willie Moore on 4 Jul 2008 19:09 Geoff, I agree, rewritting a lot of SQL from your DBF queries can take forever <g>. Regards, Willie "Geoff Schaller" <geoffx(a)softxwareobjectives.com.au> wrote in message news:486b6752$1(a)dnews.tpgi.com.au... > Henry. > > You need a class based approach, such as that which I am doing now with > about 12 companies around the globe. Check out my website for white > papers (it is slow at the moment so please be patient - our fault) at > www.sofwareobjectives.com.au/voconversion > > There is a lot of reading there. > > Basically, we can convert a DBF oriented app to SQL in a few weeks (say > 250,000 lines of code, 150 tables and 50 browsers) and your code will > largely stay in DBF syntax. This can work for MS SQL, DB2 or Oracle. > > Or you can write lots of SQL and take forever <g>. > > Geoff > > > > "Henry" <ZodcomAG(a)yahoo.com> wrote in message > news:cb073750-0080-4c2c-940f-ee82475c3006(a)e53g2000hsa.googlegroups.com: > >> Until now I am using dBase databases, the server is marked as disk "M: >> \", the default directorey is "M:\...", so every opening of a database >> is performed automatically on the server. >> There are only 7 computers on the net. >> >> In order to speed performance, I am considering passing to SQL. >> How can I do it with minimum edit of the existing code? >> Can I await a considerable change in performance? >> >> Many thanks for any hint >> Henry. >
From: richard.townsendrose on 12 Jul 2008 07:43
Geoff, seems like your lib will be the best way forward. presumably therefore as advantage is sql compliant, then once an app is converted to sql, it can still be set up to use advantage. richard |