forum.vdsworld.com Forum Index forum.vdsworld.com
Visit VDSWORLD.com
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 


Loadfile in Table .... very very slow
Goto page Previous  1, 2
 
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help
View previous topic :: View next topic  
Author Message
Boo
Valued Contributor
Valued Contributor


Joined: 31 Oct 2003
Posts: 599
Location: Gulf Breeze, Florida USA

PostPosted: Wed Mar 23, 2005 5:08 pm    Post subject: Reply with quote

Quote:
Well in that case I would have thought BINFILE WRITE would be just as quick.


Not sure. I seem to recall experimenting with the Binfile commands and having some issues with larger files. (It might have been a binary file issue when combining two files and using various I/O instances. I recall testing Binfile vs. vdsug.dll, and vdsug.dll won out over speed..

For plain text, it may be just as fast... I'll have to experiment a bit...
Back to top
View user's profile Send private message
jules
Professional Member
Professional Member


Joined: 14 Sep 2001
Posts: 1043
Location: Cumbria, UK

PostPosted: Wed Mar 23, 2005 5:39 pm    Post subject: Reply with quote

I wrote an 8MB file in 1.8 seconds with BINFILE, so I would have thought it was fast enough, but you are probably right that the other methods are faster still. The BINFILE command and function were rubbish anyway, and will be replaced in VDS 6 by brand new commands that use the Windows API directly, instead of using the Delphi file I/O functions. They are probably the cause of the relative slowness. VDS 6 writes the same 8MB string in 0.4 seconds.

VDS 5 @BINFILE fails (without even setting @OK() to false) trying to read in the 8MB file. This is probably a memory management problem. So VDS 5 and earlier should not be used for very large files. External DLLs should be OK as long as the data is held within the DLL and not transferred in its entirety to a VDS list or variable.

VDS 6 is also very significantly faster reading and writing large string lists, like an 8MB file with 150,000 separate lines in it.

Sorry, I keep writing "is" but of course it's "will be" for the rest of you.

_________________
The Tech Pro
www.tech-pro.net
Back to top
View user's profile Send private message Visit poster's website
jwfv
Valued Contributor
Valued Contributor


Joined: 19 Mar 2002
Posts: 422
Location: Beaufort, SC

PostPosted: Wed Mar 23, 2005 7:01 pm    Post subject: Reply with quote

No fair dropping the VDS6 teasers! You'll get everyone too worked up over it.

Notice how I am not asking questions like:

What are the new features?

When will it be released?

Notice how I'm not asking those?

_________________
Joe Floyd
Back to top
View user's profile Send private message
jwfv
Valued Contributor
Valued Contributor


Joined: 19 Mar 2002
Posts: 422
Location: Beaufort, SC

PostPosted: Wed Mar 23, 2005 8:02 pm    Post subject: Reply with quote

After I wrote the message above, I read in another thread that it was slower than expected due to problems in Delphi.

Hopefully those problems can be worked out. We all appreciate your hard work, Jules - and eagerly await the next update of this great software.

_________________
Joe Floyd
Back to top
View user's profile Send private message
jules
Professional Member
Professional Member


Joined: 14 Sep 2001
Posts: 1043
Location: Cumbria, UK

PostPosted: Thu Mar 24, 2005 9:01 am    Post subject: Reply with quote

I think it'll be worth waiting for.

It's worth mentioning that VDS 6 will also support VDS 5 runtimes, so you will be able to continue to develop projects using VDS 5 that you don't wish to migrate, and will even be able to choose to continue to use VDS 5 for simpler projects where you prefer the advantages of the smaller runtime. This is a more important benefit than you might think because VDS 6 will have the option to create integrated EXEs that don't require a runtime DLL and integrated VDS 5 EXEs are about half the size of those that use VDS 6.

So there is no reason for anyone to delay getting VDS 5 just because VDS 6 is coming in a few months time. I've been using the new VDS 6 IDE to maintain my many VDS 5 projects for a while now, and some of them I'll probably never bother to migrate.

_________________
The Tech Pro
www.tech-pro.net
Back to top
View user's profile Send private message Visit poster's website
JRoza
Contributor
Contributor


Joined: 17 Aug 2003
Posts: 182
Location: Netherlands

PostPosted: Thu Mar 24, 2005 11:42 am    Post subject: Reply with quote

Integrated runtimes in the exe file ........... that's music to my ears!
The more you tell about VDS6 the more eager I become to get my hands on version 6.
Keep on teasing us with inside ifo about the new release Very Happy
Back to top
View user's profile Send private message Visit poster's website
bbelcher
Contributor
Contributor


Joined: 30 Jul 2002
Posts: 172

PostPosted: Thu Mar 24, 2005 12:38 pm    Post subject: Reply with quote

DITTO

I to am looking forward to VDS 6.0 it sounds awsome. Very Happy
Back to top
View user's profile Send private message
Serge
Professional Member
Professional Member


Joined: 04 Mar 2002
Posts: 1480
Location: Australia

PostPosted: Sun Mar 27, 2005 11:51 pm    Post subject: Reply with quote

that sounds great jules Smile

serge

_________________
Back to top
View user's profile Send private message Visit poster's website MSN Messenger
FreezingFire
Admin Team


Joined: 23 Jun 2002
Posts: 3508

PostPosted: Mon Mar 28, 2005 12:53 am    Post subject: Reply with quote

Sounds awesome!! Keep up the good work!! Yes
_________________
FreezingFire
VDSWORLD.com
Site Admin Team
Back to top
View user's profile Send private message Visit poster's website
Cipper
Newbie


Joined: 21 Jun 2001
Posts: 22
Location: Trieste Italy

PostPosted: Tue Apr 12, 2005 12:22 pm    Post subject: Reply with quote

I have resolved! I use the list in order to load and the table in order to visualize the last records.
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    forum.vdsworld.com Forum Index -> General Help All times are GMT
Goto page Previous  1, 2
Page 2 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

Twitter@vdsworld       RSS

Powered by phpBB © 2001, 2005 phpBB Group