Searching a Table

[kpsmith]

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.

[Worm]

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.

[Corey]

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:

Corey Milner
Creative Director, Indigo Rose Software (http://www.indigorose.com)

[kpsmith]

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.

[kpsmith]

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....

[sferguson]

Hi gang,

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!