…_id, customer_name, sale_when; $ php convert.php demo < sales.sql CALL flexviews.create('demo...mview$pk` which is an auto_increment BIGINT surrogate key for the table. For… | <-- too high +------------------+ 1 row in set (0.68 sec) mysql> select sum(total_lines) from dashboard_customer_sales ;…
Post: Flexviews - part 3 - improving query performance using materialized views
April 4, 2011 By 20 Comments
Comment: PHP vs. BIGINT vs. float conversion caveat
January 11, 2008 By 27 Comments
…MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s a quick excerpt Sometimes you need to work with big numbers in PHP (gulp). For example, sometimes 32-bit identifiers are not enough and you have to use BIGINT 64-bit…
Comment: Flexviews is a working scalable database transactional memory example
May 19, 2011 By 3 Comments
… a MEMORY table which is replicated with a single UNSIGNED BIGINT and increment it at the end of each transaction…CREATE TABLE trx .trx id BIGINT UNSIGNED NOT NULL. ENGINE memory ..INSERT INTO trx VALUES 0….From ….Dear MySQL database administrator please drop us a note if you want this to be implemented in the PHP plugin! Partitioning…
Comment: PHP vs. BIGINT vs. float conversion caveat
January 12, 2008 By 27 Comments
… today on Comment on PHP vs. BIGINT vs. float conversion caveat by Windows…Here’s a quick excerpt[…] MySQL Performance Blog wrote an interesting post today on PHP vs. BIGINT vs. float conversion caveatHere’s…
Comment: Database problems in MySQL/PHP Applications
August 11, 2006 By 13 Comments
… up far more space than even a BIGINT UNSIGNED will and gaining no benefit from it… traditional database background. > Things are different with MySQL. Good design will help dictate how many … however start > to crawl. > So developing you PHP applications use test database with reasonable > amount …
