(UTC)
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 [2]  Send Topic Send Topic Print Print
Hot Topic (More than 10 Replies) Too Many Records (Read 2193 times)
NightHawk
Member
*
Offline


No personal text

Posts: 20
Joined: Feb 9th, 2006
Re: Too Many Records
Reply #15 - Feb 12th, 2007 at 10:56pm
Print Post Print Post  
Sorting by 2 fields only.. a date and a text field
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Too Many Records
Reply #16 - Feb 12th, 2007 at 11:41pm
Print Post Print Post  
How many records is she sorting?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
NightHawk
Member
*
Offline


No personal text

Posts: 20
Joined: Feb 9th, 2006
Re: Too Many Records
Reply #17 - Feb 12th, 2007 at 11:44pm
Print Post Print Post  
about 4000
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Too Many Records
Reply #18 - Feb 12th, 2007 at 11:58pm
Print Post Print Post  
It's taking 30-40 minutes to sort 4000 records by 2 fields? Something is wrong with this picture.

For example, the ZipCode database in Samples has over 43000 records. I can do a "worst case" sort on two fields on a weak computer in about 20 seconds. Normal case takes less than a second. 5000 records in "worst case" takes about 3 seconds.  5000 records at a normal case takes less than a second.

Is anything else taking a very long time?
  
- Hammer
The plural of anecdote is not data.
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1 [2] 
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge