Webpanel slows down if large ip pools are created

[GoogleCodeExporter]

Steps to reproduce:
1. Create large IP Pool with about ~50000 Adresses
2. Create VE dialog is loading now very slow, and ip adress search is very slow 
too.
3.

Actual result:
application slows down
Expected result:
no slowdown of application
Version of the product:
2.0
Server OS:
Debian 5.0
Browser:
Firefox 4.0

In the IP address search (in create ve dialog) you should try to limit ip 
addresses which are shown to a lower value. Maybe the first 256 addresses or 
one /24 subnet. 

one approach is to store every single usable address in a single database row. 
Then you can easily limit the output via a mysql limit query. 
In this case it would be better to store the ip address not in the "ip address 
form", but rather in INT form. Mysql provides the functions INET_NTOA and 
INET_ATON for converting ips for and backwards. 

For example you can use a database scheme like this:
CREATE TABLE `iptest`.`ip` (
`ip` INT NOT NULL ,
`server` INT NULL ,
`usage` SET( 'gateway', 'free', 'broadcast', 'vrrp', 'reserved', 'used', 
'additional' ) NOT NULL ,
INDEX ( `ip` )
) ENGINE = MYISAM ;

If you want get free ips in a range you can simply use the following query:
SELECT ip FROM ip WHERE (ip BETWEEN INET_ATON('10.0.0.0') AND 
INET_ATON('10.0.0.50')) AND usage = 'free' AND server IS NULL ORDER BY IP ASC 
LIMIT 100;

Regards
Alex

Original issue reported on code.google.com by bufok...@web.de on 27 Apr 2011 at 6:00

[GoogleCodeExporter]

Original comment by sibprogrammer on 28 Apr 2011 at 1:17

• Added labels: Milestone-Release2.1

[GoogleCodeExporter]

Original comment by sibprogrammer on 1 May 2012 at 10:06

• Added labels: Milestone-Release2.5
• Removed labels: Milestone-Release2.1