Access Frontend Searching Slow
I am running mysql on a gentoo linux box and I am using it to store data for my family. I am interested in migrating them from an access database to mysql while still using access as a frontend. However while doing preliminary testing I realized that searching through access was very slow, e.g. the <ctrl + f> find method takes a few minutes to procure a single match.
The database has two tables, one table containing personal information, with about 500 records and 9 fields, and the second containing sales records, with about 1000 records and 5 fields, linked together by a id number relationship.
Access is set up with two forms, one for entering new personal information, and another form for entering a sale. In the sale form, I link data from the personal information table while hiding the id number because its easier to recognize a name rather than an id number.
What my ideal goal is for them to <ctrl + f>, enter in the last name of the person, and proceeed to enter in a new sale without the process taking 5+ minutes. Is there an alternative to the find command that we can use to speed up the data.
The machine on which the server is running has VERY limited system resouces, a pentium III 550 mhz processor, 256 megs ram, and a 20 gig hdd, but somehow, I know the problem is with the way that I am trying to find data rather than the limited resources of the serving machine.
View Complete Forum Thread with Replies
Related Forum Messages:
Slow Db Access
I have worked with a few mysql dbs on different servers but i have recently been asked to work with one on nicnames. It seems horribly slow. Working in phpMyAdmin (which i had to install myself) it takes ages when i want to do anything. View the table structure, view the data..etc. Any way i can test the speed so that i can compare it against another server i work with and proove there is a speed issue and take it to nicnames cus it is crazy and is going to affect the speed of the website!!
View Replies !
Slow Table Access On Local Machine
I'm running MySQL 4.1.7-nt on my laptop, and I'm accessing it through ODBC (MyODBC-3.51.10-x86-win-32bit). I'm developing a .NET web application, but I don't think that's relevant. I already had the application running OK on my desktop, and when I created the same environment on the laptop, retrieving trivial amounts of data (5 rows) from a table is taking 6 seconds. Updates the same. IN otherwords any table access takes 5 or six seconds. (Table only has about twenty rows in it). I can connect to the database on the laptop from the desktop (i.e - application runs on desktop, retrieves data from laptop - works fine, not noticeably slower than local on desktop. If I connect the other way - application on laptop, database on desktop, it runs just as slowly as locally. The effect is the same whether I connect to 127.0.0.1 or via the machine name. Code:
View Replies !
Why Is Text Driver Access/Excel (DAO) Is Slow?
I'm using the Access/Excel (DAO) driver to connect to (*.csv) files, but every time I change the location of the file, it takes around 30 seconds before the change is made... Any idea about this? Could it be because of the Access/Excel (DAO) driver? If i'm using (*.csv) files with this driver, is there a conversion that could take that long?
View Replies !
Design Mysql Frontend
I wish to design an entirely new GUI frontend for mysql without the use of php. I would also like to avoid the readily available GUI frontends like EMS mysql manager , rekall etc. I would like to know which programming language is suitable for this purpose. Is it possible to do it with python or perl. If possible which language is better. I wish to run the frontend as a standalone application. Cross platform compatibility is also one of my main concerns. i would be using it mainly in linux, freebsd and windows. i dont wish to have a webpage frontend for mysql. the frontend has to run as a standalone application.
View Replies !
Anyone Using OpenOffice BASE As MySQL Frontend?
I recently saw OpenOffice's Base: "BASE enables you to manipulate database data seamlessly within OpenOffice.org. Create and modify tables, forms, queries, and reports, either using your own database or BASE’s own built-in HSQL database engine. BASE offers a choice of using Wizards, Design Views, or SQL Views for beginners, intermediate, and advanced users ... For more advanced requirements, BASE supports many popular databases database natively (Adabas D, ADO, Microsoft Access, MySQL)" I' am interested to hear anyone's experience with using this as a tool, development tool, or front-end builing tool for MySQL apps.
View Replies !
Which GUI/frontend (similar To TOAD) Is Recommended For MySQL Under WinXP?
After having installed MySQL on a WinXP computer I want to access MySQL and enter some statements (e.g. SELECT ...). Which Frontend is recommended for such a purpose? For Oracle databases I used so far I used Toad. Is there a similar tool for MySQL? For Oracle there is furthermore a command line interface like sqlplus.exe which allows to enter some of such SQL statements on the command line. Is there a similar cmdline tool (under WinXP) for MySQL?
View Replies !
Can Access Remotely, Cna't Access Locally (seems Backwards)
I have a database that I am trying to connect to a schema called lportal4_1_2 in mysql 4.1.13a (provided by my hosting company) runnning in fedora. I am trying to get a container to connect to it and was having problems. Since I didn't want to pollute the problem with the container, I wrote a small (hack) program that does the connection. Here is the problem: I can connect from my desktop (winxp) using a Java command line application, Mysql Administrator and mysql query browser and everything works fine. When I run the same Java command line app (using the exact same driver) I get the Access denied for user error that follows: ---- java.sql.SQLException: Access denied for user 'lportal'@'inkbrains.com' (using password: YES) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2975) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:798) at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3700) at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1203)...........................
View Replies !
Can't Access Created DB's Via PHP, Though Can Access Them Via PhpMyAdmin
I can create databases via mysql-shell and edit them. These then do show in phpMyAdmin and are editable. BUT, if I try to access these db's via a normal php-script (i.e. $ergebnis=mysql__list_dbs($server)), it only shows me one database, the test-db. (To show them, I use a for-loop which counts the elements in $ergebnis from 0 to the number smaller than mysql_num_rows($server) and then prints the string.)
View Replies !
Cpanel Can Access But For Others Access Denied
I can access my database through Cpanel's GUI with no prob, but when I tried using MySQL-front in my comp, it always give me an error access denied. I supplied correct username and pass but still no luck. and How do I configure MySQL-front to connect to my webserver's mysql db?
View Replies !
Searching A Row
i need to be able to do a search using the "LIKE" instance through all of them, but id was hoping to avoid having to do something like this: first_name LIKE "%$form{'FirstName'}%", last_name LIKE "%$form{'LastName'}%", company LIKE "%$form{'CompanyName'}%", street1 LIKE "%$form{'Street1'}%", street2 LIKE "%$form{'Street2'}%", etc.... i would have to do this like 40 times to have it search everything.
View Replies !
Searching On ý
I need to find all the instances of ý in my database, but not y. So, for example: SELECT * FROM listings WHERE descritpion LIKE '%ý%' produces anything with a y in it. How can I get only those records with a ý?
View Replies !
Help With Searching WHERE/LIKE/OR
I tried to search this on the forum, but 'where', 'like', and 'or' aren't the greatest of search terms... Given a keyword, I need to search several fields for matches. I can use %$keyword% format. This is what I have been trial and erroring: $query = "SELECT * FROM tablename WHERE field1 LIKE '%$keyword%' OR field2 LIKE '%$keyword%' OR field3 LIKE '%$keyword%'"; Can you see the error here?
View Replies !
Searching For Records
eg search for records having same email address select txtemail,count(txtemail) from `tbl_user` GROUP BY txtemail having COUNT(txtemail)>1; and it works, is that the best way?
View Replies !
Searching Mysql.com
A comment was made something to the effect that such a line in /etc/mysql/my.cnf could be used to restrict network connections to mysql to a specified IP address. I'm not quoting exactly, but the idea is that if it is desired to connect to mysql tables via say an ODBC connection, a line like bind-address = 192.168.1.175 would allow connections from a client pc with that ip addr. What if I wanted to allow 2 PC's on the LAN to connect to the mysql server on the linux box? I couldn't find help on mysql.com for this objective.
View Replies !
Searching By Tags
I have three tables: `photos`, `tags` and `tags_photos`. The `photos` table contains a unique ID and a bunch of other stuff, the `tags` table contains a unique ID and a tag name, and the `tags_photos` contains the photo ID and the tag ID for an association between a tag and a photo. In other words, any photo may have many tags and any tag may have many photos. This is great for filtering photos based on tag, but I'm now trying to allow users to search photos on multiple tags. I want users to be able to enter a list of tags and either search for photos with "all these tags" or "any of these tags". I tried the query "SELECT a.* FROM photos AS a, tags_photos AS b WHERE b.photo=a.id AND b.tag IN ($tags)" where $tags is a comma-separated list of the tag IDs from the tag names the user entered, but of course it returns photos multiple times if they have more than one of the entered tags. Any ideas?
View Replies !
Searching Algorithm
I'm developing a database for a research firm which has data they want to search for specific criteria against varying base line data - some of the questions that have been asked to get the raw data (which I will import into MySQL) are like this: how often do you use mouthwash? etc. etc. The responses for each question was structured with only 4 answers from a large group of people: no answer low medium high Using various baselines of people, I want to build a query that will accurately find matches and to also allow me to find 'close' matches - for example: if base line #1 is for a consumer who uses mouthwash a 'medium' amount of times per week, I want to find in the database how many 'hits' there are for that question - but I also want to capture 'close' hits like in this example, for this specific question, if the search finds 'low' instead of 'medium' I'd like to count that as a 'close' hit vs a direct hit (match) - then when the query is over, I'd have say, 80% matches with (for example) 60% of those direct hits and 20% close hits - I'm using PHP so I can use that to keep track of direct hits and 'close' hits.
View Replies !
Searching On Two Keys With OR?
Which version is targetted for optimization of OR searching on two keys, that is, "select * from sometable where f1 = 123 or f2 = 123", as described in http://www.mysql.com/doc/en/Searching_on_two_keys.html ?
View Replies !
Fulltext Searching
How fulltext is working!!? I have the following table with just one record! And when I do a select statement, mysql returns no hits!!! Would you explain to me what is wrong?? Code:
View Replies !
Text Searching
I am using normalization on my database tables so that I can related each table to each other.The only problem is that I am using a full text search on 4 fields. These include: descrip, title, brand, category. Now would I have to have these 4 fields in one table or could I normalize them and make split it up into 3 different tables as such. table 1) descrip, title, brand_id, cat_id table 2) brand_id, brand table 3) cat_id, category Once I have done that then would I still be able to perform a full text search on the 4 fields that I had mentioned above or would I have to keep them as one table.The main reason why I want to split them up is because in the brand and category fields I have alot of duplicate entries. Infact about 50 or so percentage of it is duplicate.I just want to try and make my dataset as small as possible as I will be having well over 2 million rows and I need the search performance to be fast.
View Replies !
Postcode Searching
I have an interesting little mysql/php problem that Im trying to get my head around. Plus I thought it was long overdue that I sign up here instead of just trolling I have a database with 3 fields from_postcode, to_postcode, service_id It tells me which postal services are available for a certain postcode lets say for instance I want to search for DN2 4SQ The match in the database would this record from_postcode - DN0 0AA to_postcode - DN9 9ZZ and then I can read the service_id's in So as you can see I sort of need to say WHERE postcode BETWEEN from_postcode AND to_postcode But that doesnt work as its a text search - so postcodes starting with DN10 wont work as they match in the same group as above Anyone any ideas as I've been all day The only way I can think is to split the postcode into 4 chunks [DN][0][0][AA] -> [DN][9][9][ZZ] Then I can use between and less than/greater than queries to find if the search postcode is between those 2 values
View Replies !
Advanced Searching
I want to search the complete tables i am having. The searching should be like the following....Say if i give the word 'caring' as the keyword for search the i should get the result from the fields which is similar to caring.. ie it should display all the fields having data ..care,caring,very caring..etc hope u all got it..I used the fulltext function and also match() But i am not getting the desired result.
View Replies !
Searching A Column
I have a database of filenames that when someone searches for a filename it uses LIKE against the column for wildcard matching.Some of the files I have entered recently have a $ (dollar sign) as part of the filename, and they are not showing up in the results. Do I need to slash them in order to work? like '%test$test%'
View Replies !
Searching Across Table
Suppose I have 5 fields in my database (A, B, C, D, E). Is it possible to write a query that searches all of them? I know that I can do Code: select A from my_table where a like '%ponies%' or b like '%ponies%' or c like '%ponies%' or d like '%ponies%' or e like '%ponies%' But if I have 100 fields, that would be unwieldy. I could do this very easily with PHP but would prefer to optimize the DB query.
View Replies !
Searching By First Letter
I need a query to search for entries in my table where the first letter of last_name and first_name is the selected value. So, when I click on the letter 'a', it would return all entries where the last_name and first_name begin with the letter a.
View Replies !
Searching Date
I have a date type field in my table. Say the value is this month of this year - what sql would i need to search for dates which are a certain time before todays date, like 3 months?
View Replies !
Searching Zip Codes
I have a table that includes a US zip code column. It stores a 9 digit zip in the form of 12345-6789. I would like to be able to search it with accuracy to only the first 5 digit part, but I'm not getting far with my own ideas. Can this be done?
View Replies !
Searching In 2 Tables
I got this code and it works fine exept that it only searches in in column, is there a way to do a search in 2 columns PHP Code: SELECT * FROM {$sqlprefix}link WHERE description LIKE '%$term%' AND active = '1' ORDER BY out DESC
View Replies !
Searching In All Tables
If I needed some type of information lets say... errr "xlordt" information... Say I need to query this users data... but.. I dont know in what table this user is in.... Is it possiable for me to add a query to search in all tables? and give me that users information? errr probably something stupid.. but... I need to know if its possiable or not.
View Replies !
Searching Keyword
i would like to be able to search a keyword, and match it against 2 columns. so for example, I have cli_fname and cli_sname fields, and I want to be able to search for "mark williams" and have mysql match the search term against the two fields, but treated as one (if I am making sense) I have tried CONCAT(cli_fname,' ',cli_sname) as cli_name, but if I add %keyword% LIKE cli_name, I get an "unknown field" error. is there a way to do this?
View Replies !
Searching Several Fields
I'm after a solution to a problem which I can solve by doing lots of queries, but was wondering if there was a more elegant mySQL way of doing it.I'm writing a calendar app which will display dates of various courses. Each course has several dates associated with it stored in several fields of a database.I want to be able to search all the date fields (stored in datetime format) and return rows which contain dates within a certain range (i.e. for a specific date).However, what I want to be able to do upon getting the row result (or several rows for several matches) is for mySQL to be able to tell me which field the match came from.
View Replies !
Searching %% With Index
I try to search %name% from a field that already indexed, but it did not work, if i search only name%, then the indexed will be used. Anyone know how can i solve the problem so that I able to search the text faster? MYSQL fulltext looks like a solution, but too bad it cannot search word like: Software Engineer -> search "ware", will not work -> search "Software", then work right?
View Replies !
Searching With Mysql
My table in MySql looks like this (id:int, usrid:int, title:char(30), descr:text, imgname:char(30), imgpath:char(30), links:char(20) ); I would like to enable users online search this tables "title" and "desc". What is the best way to enable users to search for a srting of words and find matches that contains the string or part of the string.
View Replies !
Simultaneous Searching
I am trying to build a system that will allow for a "Google-like" search of our site. Each page consists of a title and various other content (TEXT) fields. What I'd like to do is a search something like: select pageid from pages where title is like '%query%' or summary is like '%query%' or content is like '%query%'... for all 20 different query terms. Then I'd like to automatically highlight the matching result. Now, it seems like a bit inefficient to essentially do the same query on so many different columns...the alternative is to do a separate select statement per column (i.e., limit the WHERE to 1 column), but that also seems inefficient.
View Replies !
Searching Through Different Fields
I'm trying to create a search bar on my webpage. My web page is a clothes shop and I want to be able to search by brand, shop name, dept etc... Each of these is a field in the table product. Code:
View Replies !
Searching Ampersands
i have created a query that is to search text in my database and it goes well. but my friend the other day is complaining that he did not find what he search in the database but actually the data is really in there.. the data contains ampersand(&) like 'tom & jerry' and also a text 'mcs of tampa inc'. my query is this: select * from mytable where mytext like '%mcs of tampa inc%' select * from mytable where mytext like '%tom & jerry%' in the first query, it runs ok when the text is 'mcs of tampa' but if i complete it to 'mcs of tampa inc' no results has been return. is theres a special characters their?
View Replies !
FULLTEXT Searching For *?
I have just discovered the power of FULLTEXT. But i would really like to be able to search for words like *smile*. That is, smile with astersisks around it. Is there an escape character for * that lets me do this?
View Replies !
Fultext Searching
I would like to set up a search for some sections of my site. When I try to add fulltext, I get the error that the table type doesn't support fulltext. This may be because it is not MyASI...or whatever that is. Anyway, what are my options? Do I need an index? Would searching without one be painfully slow? Can I just conver the table type or will this cause unexpexted problems? The average row has about 1-8-25 words and I shouldn't exceed a few hundred for a while. This is a brand new site.
View Replies !
Searching Records
say i have two tables! one tables with car news and the other table with pictures of these cars. the tables: cars: name model engine pictures: small_pic large_pic waht i want to do is get the name and then search the small_pic column in my pictures table and then output this along with my article. e.g car name: ford i have 3 pictures in my pictures table for this car ford1.jpeg ford2.jpeg ford3.jpeg i want to output ford1.jpeg!! do i have to use a LIKE query? basically i want to show the article and the picture on the side of it.
View Replies !
Searching For Duplicates
I have a table named "article" with a mere 5,000 rows. I would like to count the duplicate titles. The following query just hangs (or at least takes longer than 10 minutes as I killed it at that point): SELECT count(*) AS article_count FROM article AS a1 LEFT JOIN article AS a2 ON a1.title=a2.title Titles could be as long as 150 characters. The column named "title" is full text indexed. What am I doing wrong? I would also like to check the article bodies for duplicates. The column named "body" could be as long as 10,000 characters and is full text indexed. Whatever solution there is for title duplicates, I would like it to also work for body duplicates. Finally, the article table is going to get a lot bigger. It needs to work with 100,000 rows or more.
View Replies !
Searching Columns?
i have a user management system in the making that stores info in a mysql DB. For various admin functions i want to be able to search for users. I want to be able to search by fields: 'username' 'fname' 'lname' and 'id' can i do something like: "SELECT * FROM UMS_Users WHERE $field CONTAINS '$search'" where $field is the field to search by and '$search' is the search term.
View Replies !
Searching A String
1. I have a list of states in a single variable, as such. AZ CA NY NM OR 2. What is the best method to pull a match on a single state? WHERE variable is LIKE value? In JavaScript, I would use the indexOf like so. if(var.indexOf(value) > -1){ THEN TRUE } Is there something that matchs the JavaScript IndexOf ? TYIA!
View Replies !
Searching A Table
I have a book at home that can probably help me figure it out. But until I return there this weekend, can someone give me a quick example of how to search a table and then out put a specific row. Perhaps a simple table such as Name Scores Paul 30 Tom 50 John 40 I'm just looking to search the table, find the match, and the output the correct scores.
View Replies !
Searching MySQL
I would like to search a MySQL database for a search term. I would also like it to be lenient to users. I want it the search to look for patterns, even if there are blank spaces between them.
View Replies !
|
TRACKER
