home *** CD-ROM | disk | FTP | other *** search
- Newsgroups: comp.databases
- Path: sparky!uunet!charon.amdahl.com!pacbell.com!sgiblab!zaphod.mps.ohio-state.edu!sol.ctr.columbia.edu!eff!news.byu.edu!ux1!fcom.cc.utah.edu!tim.src.utah.edu!tim
- From: tim@tim.src.utah.edu (Tim Ma)
- Subject: Re: Paradox 4.0 speed (?)
- Message-ID: <tim.5.721094115@tim.src.utah.edu>
- Lines: 29
- Sender: news@fcom.cc.utah.edu
- Organization: University of Utah
- References: <tim.1.720996716@tim.src.utah.edu> <troj.721089339@cwis>
- Date: Fri, 6 Nov 1992 23:55:15 GMT
-
-
- >>An inquiry to all users of Paradox 4.0 out there. We recently upgraded to
- >>4.0 after reading articles and ads that highly touted the improved speed of
- >>Paradox 4.0 (claims that it was much faster that FoxPro 2.0). I am
- >>impressed with some of 4.0's new features, but SPEED is does not seem to be
- >>one of them. I have a simple script written in 3.5 that randomizes the order
- >>of records in a file. All it does it import that file as a single TEXT
- >>field, tacks on a random number in anothe field, sorts on the random number,
- >>and then outputs the randomized file. To my surprise, it runs almost 50%
- >>slower in 4.0 thanit did in 3.5 (14 minutes vs. 10 minutes). I'm running a
- >>386SX with 4M of RAM. Any ideas or comments?
- >
- >Wait now... When you say you're doing a sort on the data, does this mean
- >that you're performing a sort in PAL, or that you're incrementally updating
- >the index? If you're incrementally updating the index, do you really need
- >to? You could more than likely improve your performance by updating the index
- >only when you're done with all your insertions.
- >
-
- I am doing a PAL "sort" command on this field. I guess I could index the
- field then after I assign all the random numbers, update the index,
- but I wasn't doing that in 3.5 and it would seem surprising that 4.0 needed
- this little tweak to make it run faster (or even just as fast).
-
- Thanks for the comments,
-
- Tim Ma
-
-
-