I am trying to put together a very large MySQL table with over 35 million rows in the database MySQL.
I'm new to this so I am just trying to understand how this works, and any limits.
I am wondering how I can sort the new items in order while someone is still using the MySQL file.
Will the system take care of all of this?
I will need to add more items and then sort them into the proper order, the more entries to any one point will then need to be sorted to order.
I was thinking of using an index sort then the pointer would point to each row in the MySQL database table.
I would have to create the sortkey for each row in the database and then transfer that to some sort of an array to sort.. the index would point to the row.
Then when finished I would be able to search thru the database in sorted order and then send the rows out to the customer for display.
to narrow down the search I was thinking of using the first character to find all of those and illuminate the search of 35 million records. maybe some of you know the trick to finding something quick or maybe the MySQL will figure that out too.
for j=1 to #rownumber I=idx(j) display the row that matched what the customer was looking for. next j
Since you will have 35M records, the only thing I'd suggest is that you place an index on items you want to sort. SQLite and other databases use a B+ tree to index and therefore all items are in sequence as you enter data. Remember SQLite is not managed like MYsql. If you have a lot of traffic, be aware that since SQLite is not managed, locks do not take place at the record level, they lock the entire DB for that instance. en.wikipedia.org/wiki/B+_tree
If you want to generate Run Basic code from the database download the SQLite manager. You can enter a query, execute it, and then generate the Run Basic code from the query. Using the rbGen code, you can give it a database table and it will generate a management system for the table. You can also give it tables relations to generate drop down, radio, or check boxes used for selection in the maintenance section of the code.