craftleft.gif (3002 bytes)QuickTable
Home | API | Tutorial | Download | Support | Contact topblack.gif (108 bytes)


QuickTable User Cp  |  Register  |  Members  |  Search  |  Help
    |- QuickTable Discussion Forums > General QuickTable Support/Help Post New Topic   Post A Reply
searching record printer friendly version
next newest post | next oldest post
Author Messages
mohan_be{@}yahoo.com
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

Hi,
How do u implement searching algorithm if u have 100,000+ records?Wouldn't it take much time to search?

Suppose my table strucure
I have five acolumns and 100,000+ records.

A B C D E
xxx yyy zzz ggg uuuu
... ... ... ... ...

My search criteria is B=ggg
How do u locate record with B=ggg?

thanx
mohan

admin{@}quicktable.org
Unregistered
Edit or delete this message Reply w/Quote
Posted Wednesday, December 31, 1969 @ 23:59:59  

when you have 100,000 records quicktable's search might be slow, because it searches through each row. I would suggest to use the search feature in database using query and show the query results in quicktable, rather than quicktable itself doing the search.

Ben

Post New Topic   Post A Reply Jump to:
Contact Us | QuickTable - A Java DBGrid | Privacy Policy All times are GMT -5 Hours.
Welcome to QuickTable Forums, Guest!  
Login
Username :
Password :
In order to fully utilize the abilities of this board, you are required to register as a member. Registration is free, and allows you to do lots of things including turning on or off certain features of this board. Register now!
Powered by CuteCast v2.0 BETA 2
Copyright © 2001-2003 ArtsCore Studios