I'm sorry to say it is not Access that is slowing you down :>(
Actually I have just the thing for you, almost as if it was made just for your use. It is a small library and 'find client' form designed to be integrated into databases like yours. I have attempted to design it in such a way as to be easy to do this integration. It uses filters to 'drive' the actual work form that calls it. I'll put the link to download it here tonight. If you use it all great, if not I'll point out the code fragment you will want to use in your form. On 6/21/07, Chris Moore <[EMAIL PROTECTED]> wrote:
What I have is a single table (flat file) that contains client data about cases that have to have fields updated as progress is made on said case. There is approximately 12k records, so when searching for a record to append to or to check the status of, it takes to long to go through the records using the 'Find Record' function of Base. So what I need is a way to search the database for individual records and have the records displayed in my form on a per record search with more speed than 'Find Record' provides when searching for a single record. I know what your talking about with the select statement. I can also use a simple query, SELECT * FROM `ABC` WHERE ( ( `DocNo:` = '000-111' ) ), that does exactly what I need it to do. I just need to figure out how to dynamically change the query (or filter) criteria, DocNo, using a text box and button setup that can be added to my form. I'm trying to move from Access to OOBase and I need to be able to have search performance close to that of Access. Right now I'm linked to the existing Access database (which may be slowing me down) and trying to come up with a way to move away from a proprietary database. I'm going to be using Base as the front-end and switching the back-end from Access to MYSQL once I get the form performing correctly. Thanks Andrew Andrew Jensen wrote: > OK, yes I think I can find the URLs, as most are sitting on my ftp > server...I'll put a few here - later this evening. > > However, given your last message. You realize that when you set a filter on > a result set you are actually adding a where clause to the select > statement. > After the filter is set and activated then you need to reload the result > set, which simply re-issues the SQL statement. > > The reason I bring this up is that if your problem is performance on > searches then your problems may be more with: > > A ) The schema ( indexes primarily ) > B) The joins used in the query > > In either of these cases using a filter, IMO, will not offer you much help. > Then again I could be wrong and often am. > > Anyway, with that in mind - I would make this suggestion. If you could > offer > some details on your database structure and perhaps an example query > that is > performing poorly, I might be able to offer some help in a more general > way. > Mean time, when I get some time later today to do so, I'll clean up the one > example I have in mind and put the link to it here. > > Till then > > Drew > > On 6/21/07, Chris Moore <[EMAIL PROTECTED]> wrote: >> >> Andrew, >> First of all thank you for your response. >> >> I did search around the forums and only found stuff about what I'm >> having problems with, long search times. I'll do some more searching. >> Do you have the URL's to the examples from the forum? If you don't have >> them handy don't spend any time on it. >> >> I do most of my scripting using Perl. I do very little command line >> scripting but with some examples I should be able to figure out how to >> adjust the scripts for myself. >> >> Thanks again, >> >> >> Andrew Jensen wrote: >> > Hi Chris, >> > >> > Well, I can tell you that at the OOoForum.org site there are numerous >> > examples of ways to set filters on forms . Using a text box for entry >> and a >> > button to apply the filter is covered specifically, as is the use of >> combo >> > and list boxes. A number of these threads include example database and >> > script files that you can download and checkout on your machine. >> > >> > Unfortunately there are some difficulties with the site that might make >> > your >> > finding these entries rather difficult, but these are being addressed. >> > >> > In the mean time, there are a number of example files that I can make >> > available for you to download. These range from very simple filtering >> > techniques to one that is rather advanced. >> > >> > My question would be which is most appropriate for you - all use >> StarBasic >> > scripts called from user triggered events on the form. >> > >> > If you could give me an idea of your comfort level with scripting >> already I >> > would be able to suggest which of the examples might be most >> appropriate. >> > Let me know here and I will follow up with the links to the example >> files. >> > >> > Drew >> > >> > On 6/21/07, Chris Moore <[EMAIL PROTECTED]> wrote: >> >> >> >> Is there a way to set up a filter that can work with a text box and >> >> button? I'm trying to avoid the find record button and want to be able >> >> to have a text entry box on a form that will filter the data for the >> >> record entered into the text box when the button is pushed. Is this >> the >> >> right way to go about this or should I be trying to use a query with >> the >> >> text box and button setup? >> >> >> >> -- >> >> Chris Moore >> >> [EMAIL PROTECTED] >> >> >> >> --------------------------------------------------------------------- >> >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> >> >> >> > >> >> -- >> Chris Moore >> [EMAIL PROTECTED] >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: [EMAIL PROTECTED] >> For additional commands, e-mail: [EMAIL PROTECTED] >> >> > -- Chris Moore [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
