It sounds a bit wierd, if you're searching thru a table getting one rec at a time. Suely you can go "Select * from myTable" to retrieve all recs. it sounds nuts to do it any other to be honest!
As for the fields, mySQL treats booleans (yes,no) as Char (1). You should of course change the type to DATE where needed.
Hope this helps
From: "Paul Owen" Reply-To: To: Subject: Another new list member with questions Date: Fri, 6 Feb 2004 10:54:01 -0000
Hi
I have to rebuild a database for someone that currently has in excess of twelve tables with around 20K records in the biggest table, the whole structure needs looking at as the original designer used char and int for everything, from dates to yes/no fields!!
The db is accessed from a VB program (which I also have to re-write) due to a severe lack of data entry validation and any error checks at all, what I would like to know is what is the best way to retrieve the records for display, if I form a collection of all the entries in the main table it takes a long time, can this be speeded up? Currently the program starts at record 1 and then just retrieves the next by its id number, if the next rec does not exist it then simply moves on, this is fine as is, but I can see some problems as this method means that unless I know exactly what I am looking for I have to cycle through all 20k records to find anything.
How long should a query on 20k records take?
What is the fastest way to retrieve records from the DB?
Does that make sense to anyone but me ;)
Thanks
Paul Owen
--
MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
_________________________________________________________________
MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
