Jump to content

Hard to explain problem...


BAS1X

Recommended Posts

Basically I have a huge 100mb wordlist of unique strings that I'll soon be entering into my database. The problem is, I also will be adding these strings after making all of them uppercase, and mySQL assumes that 'ABC' is the same as 'abc' which makes adding the same uppercase list impossibly without making it a fulltext database instead of Unique. Here in lies the problem... This database will also be receiving words from users that submit them from my site, but I don't want this database to be filled with duplicate words unless they have some different case in them like: 'abc', 'aBc', 'ABc' etc...

 

is there ANY way to get around this at all?

 

Also...

 

 

I also need some new way to get the size of a table without doing mysql_num_rows. I expect this database to be around 15 million unique strings when it's done, and mysql_num_rows take forever to do with only 1 million.

 

SORRY~ SOLVED MYSELF

Link to comment
https://forums.phpfreaks.com/topic/2727-hard-to-explain-problem/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.