View Full Version : Searching a Table
12-08-2003, 08:48 PM
Is it possible to search a table directly or do you need to pull
each value from the table to a string and then do a string search.
Performance seems to take a big hit using the string method.
you could use a for loop to enumerate through the table testing against the column(s) you want, then insert them into a blank table to create a table that holds all of the hits.
A little scary, that's almost like a query resulting in a recordset.
Just a thought.
12-08-2003, 09:32 PM
For advanced data handling SQLite plug-in is definitely the way to go, you will love it, it's incredible... It's coming out in the next week or so... I've attached a sneak preview of the demo here:
Creative Director, Indigo Rose Software (http://www.indigorose.com)
12-09-2003, 07:11 AM
Thanks Worm. That's pretty much what I'm doing but with a repeat loop ending when the count exceeds the # of records in the table.
I added a status dialog and "feels" faster. I'm going to bump the dataset up to a few hundred records and see how bad performance really is. I'm only working off of a 15 record set right now.
I just figured there must be a way to search the table directly but guess not...couldn't find it in the LUA documentation either.
As for the SQL plugin ... Can't wait to try it.
12-09-2003, 10:42 AM
I'm retracting my performance issue...
I think the performance issue was becuase i had the debug mode set to on. A query of 500+ records only takes about 1 second to search. Not bad at all....
12-12-2003, 01:10 PM
Is the SQLite plugin still on track for availability on Dec 15?
If so, is there any documentation available pre-release that could be downloaded and digested ASAP?
I hate to tease myself, but...
I've got a hot project on the plate beginning next week and it seems like the plugin is going to be THE way to go!
Powered by vBulletin™ Version 4.0.6 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.