SQLMaster conversion is slow
in [Visual Objects]
|
From: Geoff Schaller on 5 Aug 2010 18:29 Well it didn't stop you emailing me in the past <g>. An obvious question of use is certainly appropriate for the forum but when you get down to nuts and bolts that involve the internals of the product, well I am really the only person who can help. I am also away for a week (going to Broome for a wedding) so I probably can't respond for a while. Geoff "Rene J. Pajaron" <rjpajaron(a)gmail.com> wrote in message news:c1e17cfb-7f6d-4bc6-bd60-7fe15364dd78(a)z30g2000prg.googlegroups.com: > Hi Geoff, > > You do not mind me directly contacting you? > > If you don't mind, I will email you this weekend after I resume my > research. > > Lots in the pipeline, lots to learn..... > > Thanks, > > Rene > > On Aug 5, 5:36 am, "Geoff Schaller" > <geo...(a)softwarexobjectives.com.au> wrote: > > > Possibly too, although if he is using his local PC (which I believe he > > is) then this shouldn't be a problem. However he hasn't contacted me > > directly, which everybody else does <g>, so I don't have any other > > information. > > > > "Willie Moore" <will...(a)wmconsulting.com> wrote in message > > > > news:i3c8of$qbl$1(a)speranza.aioe.org: > > > > > > Geoff, > > > > > My guess would be that the csv location is not valid. I believe that was the > > > issue I had a few years back. > > > > > Regards, > > > Willie > > > > > "Geoff Schaller" <geo...(a)softwarexobjectives.com.au> wrote in message > > >news:4c595c32$0$34568$c30e37c6(a)exi-reader.telstra.net... > > > > > > > Bulk insert works fine for almost all people using it that I know (and > > > > yes, there are quite a few). Send me your DBF and let me see if I can > > > > upload it. > > > > >
From: Geoff Schaller on 5 Aug 2010 18:31 Rene, There are about 10 people using this commercially and they are not having problems. I can import here without problems. Start with a very small and simple database just to confirm the concept. It must work and it does. Geoff "Rene J. Pajaron" <rjpajaron(a)gmail.com> wrote in message news:85b97e45-b7e3-49d4-bc0b-e11812db389c(a)v32g2000prd.googlegroups.com: > Hi Geoff, > > Following everything you said. > > Bulk Insert is still dead on tracks. But when I unchecked this it > will do the insert but very slow, hence this is my problem. > > You said, Bulk Insert is faster so I keep trying it, but still do not > see data being inserted after that. > > Memo is not a problem, tables I use do not have MEMO fields. > > No index use. Just to isolate the problem. > > Anyway, I will continue my research this weekend. > > Thanks, > > Rene >
From: Rene J. Pajaron on 6 Aug 2010 02:48 Thanks Geoff, I have staff here doing all the test now. I will do mine this weekend. Details soon... Rene On Aug 6, 6:29 am, "Geoff Schaller" <geo...(a)softwarexobjectives.com.au> wrote: > Well it didn't stop you emailing me in the past <g>. > > An obvious question of use is certainly appropriate for the forum but > when you get down to nuts and bolts that involve the internals of the > product, well I am really the only person who can help. > > I am also away for a week (going to Broome for a wedding) so I probably > can't respond for a while. > > Geoff > > "Rene J. Pajaron" <rjpaja...(a)gmail.com> wrote in messagenews:c1e17cfb-7f6d-4bc6-bd60-7fe15364dd78(a)z30g2000prg.googlegroups.com: > > > Hi Geoff, > > > You do not mind me directly contacting you? > > > If you don't mind, I will email you this weekend after I resume my > > research. > > > Lots in the pipeline, lots to learn..... > > > Thanks, > > > Rene > > > On Aug 5, 5:36 am, "Geoff Schaller" > > <geo...(a)softwarexobjectives.com.au> wrote: > > > > Possibly too, although if he is using his local PC (which I believe he > > > is) then this shouldn't be a problem. However he hasn't contacted me > > > directly, which everybody else does <g>, so I don't have any other > > > information. > > > > "Willie Moore" <will...(a)wmconsulting.com> wrote in message > > > >news:i3c8of$qbl$1(a)speranza.aioe.org: > > > > > Geoff, > > > > > My guess would be that the csv location is not valid. I believe that was the > > > > issue I had a few years back. > > > > > Regards, > > > > Willie > > > > > "Geoff Schaller" <geo...(a)softwarexobjectives.com.au> wrote in message > > > >news:4c595c32$0$34568$c30e37c6(a)exi-reader.telstra.net... > > > > > > Bulk insert works fine for almost all people using it that I know (and > > > > > yes, there are quite a few). Send me your DBF and let me see if I can > > > > > upload it. > >
From: Rene J. Pajaron on 6 Aug 2010 02:49
Geoff, I was testing it on very small DBF too. I will more informative later.... Enjoy your weekend.... Rene On Aug 6, 6:31 am, "Geoff Schaller" <geo...(a)softwarexobjectives.com.au> wrote: > Rene, > > There are about 10 people using this commercially and they are not > having problems. I can import here without problems. Start with a very > small and simple database just to confirm the concept. It must work and > it does. > > Geoff > > "Rene J. Pajaron" <rjpaja...(a)gmail.com> wrote in messagenews:85b97e45-b7e3-49d4-bc0b-e11812db389c(a)v32g2000prd.googlegroups.com: > > > Hi Geoff, > > > Following everything you said. > > > Bulk Insert is still dead on tracks. But when I unchecked this it > > will do the insert but very slow, hence this is my problem. > > > You said, Bulk Insert is faster so I keep trying it, but still do not > > see data being inserted after that. > > > Memo is not a problem, tables I use do not have MEMO fields. > > > No index use. Just to isolate the problem. > > > Anyway, I will continue my research this weekend. > > > Thanks, > > > Rene > > |