New answers tagged

0

Fuzzy matching made no sense, given the number of entries I would be dealing with. I needed something to quickly tell me whether or not a duplicate already existed. Consequently, I ended up creating hashes of all unique combinations for a single company. For example, if three different sets of information about Company A were obtained: Set one has hashes ...


1

My solution of this would be use relation tables instead of merging ids, use uniqueness for tables phone number, email, and website etc. and insert with IGNORE command like Insert ignore into emails values (5,a.a@a.com); If you use the IGNORE keyword, errors that occur while executing the INSERT statement are ignored. For example, without IGNORE, a ...


0

For your web application build on PHP 5.5 and MySQL 5.1, having 150-200 concurrent connection,you should plan at least following configuration. [i] RAM - Start with 2 GB and upscale if performance is low. [ii]vCPU - Start with 03 vCPU core [iii] HDD - SSD RAM/vCPU is upgradeable anytime with 10 minutes of downtime. It is always trade off between ...


1

Yes, you are right. Memory is used by dormant databases I mentioned this in the following posts over the years Nov 13, 2015 : #1041 - Out of memory issue in mysql Apr 22, 2014 : Do Inactive MySQL Databases Consume Memory? Apr 21, 2014 : Adding new tables -- memory usage increases Lots of tables ? Lots of columns ? Of course, that is less memory for ...


0

(Technically, this is 'not an answer', but claim it needs to be said.) There will be an arbitrary number of columns, correct? Then (1) the output is impractical, and (2) it would be virtually impossible to generate the output in SQL. So, (1) rethink the requirement, then (2) consider whether to do it in PHP instead.


2

According to the MSDN page for PDO::setAttribute, PDO::SQLSRV_ENCODING_UTF8 is the default value, so setting it explicitly probably wouldn't change the behavior. Try the other option, PDO::SQLSRV_ENCODING_SYSTEM, which seems to have worked in this case from the MSDN forums: Some characters improperly retrieved through PDO driver.


0

FULLTEXT needs space to be space, not a "letter". That is, you cannot have spaces in a "word". I would write application code to ignore 'short' words (such as 'g') and end up with WHERE MATCH(alternate_name, product_desc, keywords) AGAINST ('+moto +plus'; IN BOOLEAN MODE) AND ( alternate_name LIKE '%moto g plus%' OR product_desc LIKE '%...



Top 50 recent answers are included