Article View: borland.public.cppbuilder.database.multi-tier
Article #270Re: Other best options exists?
From: John Graham
Date: Sat, 24 Aug 2002 11:51
Date: Sat, 24 Aug 2002 11:51
37 lines
2039 bytes
2039 bytes
�::*��������Eduardo wrote: >Other best options exists? > >Hi All > >I working with to much big data 5 million regs. > >What are the best (speedy) to work with it? > >I use Paradox, there are other options to Builder C++? > > >Thanks > >Eduardo > > > > Eduardo, I assume that your problem with speed involves a search for data either to display or to update. Paradox is primarily an end user database management system in my opinion and may start to bog down when row counts in your tables get that high. I'm not familiar enough with its capabilities to comment, but you should have the option of using indexes on the tables. If you're not using them, it's a good idea to give them a try. Any of the "SQL" database management systems such as Oracle, MS SQL Server, etc. are your options. To those systems five million records is a drop in the bucket! Regards, John
Technical Details
Message-ID:
<3D677350.6060402@salts.navy.mil>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!news-in-sterling.newsfeed.com!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailReferences:
<3d59fef1$1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,4da9fe4b27fb3b3a X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2002-08-24 05:17:43 PST Message-ID: <3D677350.6060402@salts.navy.mil> Date: Sat, 24 Aug 2002 07:51:44 -0400 From: John Graham <jgraham@salts.navy.mil> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.0.0) Gecko/20020530 X-Accept-Language: en-us, en MIME-Version: 1.0 Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Re: Other best options exists? References: <3d59fef1$1@dnews> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 8bit NNTP-Posting-Host: 163.12.6.12 X-Trace: newsgroups.borland.com 1030189903 163.12.6.12 (24 Aug 2002 04:51:43 -0700) Lines: 40 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!news-out.nuthinbutnews.com!propagator-sterling!news-in.nuthinbutnews.com!news-in-sterling.newsfeed.com!skynet.be!skynet.be!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail