Jump to content

angelcool

Members
  • Posts

    160
  • Joined

  • Last visited

    Never

Contact Methods

  • Website URL
    http://www.angelcool.net

Profile Information

  • Gender
    Male
  • Location
    Los Angeles

angelcool's Achievements

Member

Member (2/5)

0

Reputation

  1. Hello, I need to to replace the domain name and part of the URL to another domain name. So, http://www.samplesite1.com/subsite/ gets changed for http://www.samplesite2.com That way users going to samplesite2 will see the content of the subsite with samplesite2 domain in browser. any help is apreciated. Thanks
  2. I just did a ./configure --help and found: NOTE: Not all extensions can be build as 'shared'. Does it must be shared for your needs? I would try without shared keyword.
  3. --with-unixODBC=shared,/export/appl/pkgs/unixodbc/latest \ Why is there a comma there? also do a cd to that directory and make sure the libraries are present.
  4. PHP can't do it natively yet. You need to use PDFTK along with PHP's passthru(). There is a link to sample code in the bug report. Cheers!
  5. Hello community, I have requested a new feature to the PHP Group. What is this feature about? Dynamically populating PDF form templates using FDF/XFDF text files. The goal is the user gets to download the updated version of the PDF template. Feature requests are submitted through the bug reporting section, the feature request id is #61647. ( https://bugs.php.net/bug.php?id=61647 ) Please cast your vote If you think this feature can help you someday. Angel P.S. I hope this is the right section.
  6. I figured it out already, just specify a blank header in htacces: HeaderName ../header.html
  7. Hello community, I want to remove the path in a directory index. http://angelcool.net/NEWangelcool.net I want to remove Index of /angelcool.net/NEWangelcool.net/tutorials . I managed to remove the parent directory link using IndexIgnore .. in htaccess. Does anyone know how to remove the directory path ? Thanks
  8. For testing, all it stores are random numbers. I am eventually planning to hit 10 GB (now is 1.2GB), and test/feel performance on different queries.
  9. Basically what I wanted is the opinion from someone experienced using indexes in big tables (10GB~20~30GB); I am testing MySQL, so far the test table I created reached 1.2 GB, now I can tell/feel how an index(primary key,auto increment) will increase performance for a SELECT query. The table has 10,000,00 rows, a SELECT without index (full scan) takes about 12-18 seconds with an index query the time is less than 1/4 of a second. On the other hand, I have read that the indexes will slow down the speed of writing queries (INSERT, DELETE, UPDATE), since every time a record is changed the indexes must be updated (I understand that a solution for this issue could be setting up replication and redirect all your write queries to the master and read ones to the salves ). So, Does indexing advantages overcome writing disadvantages ? Also, what if it is a complex query that required a comparison in a non-index column in a 30GB table? You executed and go to lunch ? Anyone out there managing a big table/DB?
  10. Do indexing advantages overcome their advantages for large tables?
  11. ...well the id in the table was indexed, so look all those timers!! DB is now 1.2GB with 10,000,000 rows!
  12. mysql> create index randomnumbers1 on RandomNumbers(random1); ERROR 1170 (42000): BLOB/TEXT column 'random1' used in key specification without a key length :'(
  13. mysql> explain extended select count(*) from RandomNumbers where random1='XPHACFYG22422DXCCH155RE682AVEEZ2'; +----+-------------+---------------+------+---------------+------+---------+------+---------+-------------+ | id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | +----+-------------+---------------+------+---------------+------+---------+------+---------+-------------+ | 1 | SIMPLE | RandomNumbers | ALL | NULL | NULL | NULL | NULL | 5797265 | Using where | +----+-------------+---------------+------+---------------+------+---------+------+---------+-------------+ 1 row in set, 1 warning (0.07 sec) mysql> What column in the explain indicates the full scan ?
  14. What parameter indicates the full scan you are talking about ?
×
×
  • 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.